View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
glyn glyn is offline
external usenet poster
 
Posts: 4
Default 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