ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error 1004 in Excel 97 when trying to unprotect a worksheet (https://www.excelbanter.com/excel-programming/351633-error-1004-excel-97-when-trying-unprotect-worksheet.html)

glyn

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


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com