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.

"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