WestwegoMans' Forum

Computers, Websites & Forums => MS Excel => Topic started by: WestwegoMan on Jan 23, 2015, 5:03 PM

Title: Protect and unprotect a sheet. (VBA)
Post by: WestwegoMan on Jan 23, 2015, 5:03 PM

To protect using a macro:

Code: [Select]

Worksheets("Sheet1").Protect Password:=""Note: you can put a password in the parentheses.

To unprotect:

Code: [Select]

Worksheets("Sheet1").Unprotect Password:=""Note: you can put a password in the parentheses.

Text Only | Text with Attachments