Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro runtime 1004 error on opening worksheet Shaggyjh Excel Discussion (Misc queries) 5 May 6th 09 12:37 PM
Error 1004 from worksheet activate procedure mikeburg[_9_] Excel Programming 1 July 14th 05 01:25 AM
Set worksheet range runtime error 1004 DaveP Excel Programming 1 March 29th 05 07:13 AM
Unprotect worksheet error fiona Excel Programming 3 October 4th 04 12:34 PM
HELP!! Excel 2000 Copy of worksheet class failed run time Error 1004 Martin[_6_] Excel Programming 1 August 2nd 03 03:16 PM


All times are GMT +1. The time now is 04:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"