Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unprotect sheet macro
Hi All
I have a macro that is listed below It will be used for security keep people from unauthorized use of my excel file Anyways. The macro listed below works gret. However I need to add additional code to have the macro unprotect each sheet before it can clear the cells as stated in the original macro. Is anyone able to help with the code needed to unprotect each sheet. Thanks -- crunchin numbers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
unprotect sheet macro
See one reply to your other posting in this same group
Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 13:38:00 -0700, belvy123 wrote: Hi All I have a macro that is listed below It will be used for security keep people from unauthorized use of my excel file Anyways. The macro listed below works gret. However I need to add additional code to have the macro unprotect each sheet before it can clear the cells as stated in the original macro. Is anyone able to help with the code needed to unprotect each sheet. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unprotect sheet & workbook dim out | Excel Worksheet Functions | |||
Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
how to Unprotect sheet | Excel Discussion (Misc queries) | |||
Unprotect sheet button!?? | Excel Worksheet Functions | |||
Macro to Unprotect sheet!? | Excel Worksheet Functions |