G
glyn
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
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