Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
I have an Excel Protected template file (2000') that I need to unprotect several sheets (20) in order to perform work, then protected back with the same password to distribute to users. Currently I am doing this manual which can be time consuming. How can I create a macro to protect/unprotect sheet with a click of a button? Thanks for any help and suggestion. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
Please help!!! Using code to password-protect and unprotect... | Excel Programming | |||
Password - Protect, UnProtect | Excel Programming | |||
Protect/unprotect sheet with password with VBA? | Excel Programming | |||
Macro to protect and unprotect | Excel Programming |