MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to protect/unprotect sheets w/ password


Posted by Dwight on August 29, 2001 8:41 AM

I would like two macros to be able to quickly protect and unprotect numerous worksheets using the same password. When I try to record the macros, there's no reference to the password and the macros basically just say "ActiveSheet.Protect" and "ActiveSheet.Unprotect".
Can someone help me with VBA code?


Posted by Dwight on August 29, 2001 9:02 AM

DISREGARD; found in earlier post EOM