MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro to lock all worksheets


Posted by Paul on December 20, 2000 6:47 PM

Are there any macros that will lock an unlock all the sheets in a workbook at one time? I want the user to have to put in a password when the button to unlock the sheets is pushed. Thanks for your help.


Posted by cpod on December 21, 2000 8:42 AM

Dim WS
For Each WS In Worksheets
WS.Protect "password"
Next


Dim WS
For Each WS In Worksheets
WS.Unprotect "password"
Next