Try setting the "TakeFocusOnClick" property of CommandButton1 to False.
Excel97 is picky about this.

Troy

"jontait " wrote in message
...
Hi troy

Thanks for your help but unfortunately it gave me an error.

When I clicked on the button I got the following message:

Runtime error '1004'
Unprotect method of worksheet class failed

Then when I hit the debug button the first line of your code is
highlighted.

Do I need to change something? I'm working on Excel 97 at the moment,
does that have any bearing?

Thanks again for your help - much appreciated


---
Message posted from http://www.ExcelForum.com/