Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 1004 in Excel 97 when trying to unprotect a worksheet
I am getting an error mesage 1004 when trying to unprotect a worksheet in
Excel 97 it seems to work in 2000, 2002, 2003 but not 97 i am using the codename of a worksheet to unprotect IE sheet1.unprotect It is actually working sometimes and then not others Also the other problem i am having is with screenupdating I am using application.screenupdating = false when the macro is ran in 2000,2002 it works fine but in 2003 and 97 it is if screenupdaing = true Help Please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro runtime 1004 error on opening worksheet | Excel Discussion (Misc queries) | |||
Error 1004 from worksheet activate procedure | Excel Programming | |||
Set worksheet range runtime error 1004 | Excel Programming | |||
Unprotect worksheet error | Excel Programming | |||
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004 | Excel Programming |