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.

"Dave Peterson" wrote:

You sure you're on the correct sheet?

msgbox activesheet.name



Chad wrote:

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.

--

Dave Peterson