Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection Error
Hi
unprotetcting and protecting again is the right idea :-) You may post your existing code which fails. -----Original Message----- Please Help!!! I have a macro that hides and unhides rows of cells (rows 2:16). It is ran when a command button is clicked, however, those rows are locked. So when the program is protected, VB cant run the macro to hide the rows and a 1004 error occurs. It says "Unable to set the hidden property of the range class". What can I do to protect those rows, but allow the macro to run???? NOTE: I tried unprotecting the sheet before the macro runs and then protecting it back. That doesnt seem to work. I get a 1004 error, "Unprotect method of Worksheet class failed". . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
protection error | Excel Worksheet Functions | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Protection error | Excel Discussion (Misc queries) | |||
Error with protection | Excel Programming | |||
Sub Error with Sheet Protection Enabled? | Excel Programming |