Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting an error message when I try to use VBA code
to unprotect a worksheet. The code is simple: Sheets("sheetname").UnProtect There is no password assigned. But I get an error: "Unprotect method of worksheet class failed." What am I doing wrong? Any ideas? I have no problem protecting a worksheet with VBA code (Sheets ("sheetname").Protect DrawingObjects:="True"... etc...) I get the error message only SOME of the time, which confuses me the most. Any help is greatly appreciated. Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
400 Error in Unprotect/Protect Macro | Excel Discussion (Misc queries) | |||
Unprotect | Excel Discussion (Misc queries) | |||
Unprotect worksheet error | Excel Programming | |||
Unprotect method run-time error | Excel Programming |