Re: Using Macro to protect and unprotect worksheets

I installed these macros on a sample workbook and they function properly. When I run the protect macro all the pages are protected properly and visa versa. So how does the password function work?

Code located at: http://www.excelforum.com/excel-prog...ml#post2285150

Simpson, in the future, please start your own thread. If another thread is relevant, provide a link as I've added to yours.

"Password" is not a function, it's a property of the Protect and Unprotect methods. The password can be set or changed in the Protect method. If you leave off "Password:=..." then the worksheet will become protected, but with no password.

Simpson, expanding on what Paul has already shown you, the macros on this page show you how you can allow the USER to decide the password at the time the PROTECT macro is run. It also shows how the user can be prompted to provide you the password to unprotect them. Perhaps it will be of use to you:

Protect & Unprotect all sheets in a workbook