Error unprotecting worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try setting the TakeFocusOnClick property of the buttons (if any) to False.
That's usually the culprit
 
Thanks, but that's not it. I've tried that. I've also tried selecting a
cell range to "take the focus off" of the button manually. The strangest
thing about it, is that if I run the macro by itself it works. However, when
I run the macro inside of another macro it errors. Any additional thoughts?
 
Yes, I'm on the correct sheet. Everything works correctly in Excel 2000, its
on a different computer with the Excel 97 version that the error occurs.
Does Excel 97 have a problem recognizing this sheet protection code? I know
you can manually do it in both versions the same way via
Tools\Protection\Protect Sheet, but perhaps the code is different. Any
thoughts. Many thanks.
 
Mhm... not sure what might be happening. What if you refer to the sheet
directly ?

Sheets("YourSheet").Unprotect "thepassword"
 
I worked through the error. Apparently, in Excel 97 it is necessary to
select a range before you are able to protect/unprotect the sheet in addition
to the takefocusonclick=false code. Thanks to everyone for all of your help.
 
Back
Top