Posted to microsoft.public.excel.programming

chad

external usenet poster

Posts: 273

Error unprotecting worksheet

I have encountered a run time error 1004: unprotect method of worksheet class
failed.

I have written an "unprotect the worksheet" macro that includes:
ActiveSheet.Unprotect password:="something"

When I run this macro in Excel 2000 indpenedently and referenced within
other macros it works fine. However, when I run this macro on other machines
running Excel 97, the error occurs. Any and all help is appreciated.

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Unprotecting a worksheet	Jessica	Excel Worksheet Functions	8	August 21st 08 06:43 PM
Unprotecting a Worksheet	Anney	Excel Worksheet Functions	7	August 4th 07 01:14 PM
unprotecting a worksheet	Randy123	Excel Discussion (Misc queries)	1	August 8th 05 06:11 PM
Help with unprotecting worksheet in Excel 97	Steve Mikula	Excel Programming	1	November 3rd 03 08:02 PM
Unprotecting worksheet in a macro.	Mark F.	Excel Programming	1	July 17th 03 08:38 PM

All times are GMT +1. The time now is 04:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us