![]() |
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