In protecting the worksheet the button also appears to be protected and
not accessible to the user.

Very odd. I've used Forms buttons on protected sheets for many years. The
button is always clickable and its assigned macro runs.


--
Jim
"Finance Guru" wrote in message
...
| Hello,
| I am currently running Excel 2003.
| My problem is this.
| I have a w/sheet that allows users to enter data into selected cells. In
| other cells there are various LOOKUPS base on their input. I have created
a
| Button from the Forms toolbar and attached a macro to it that allows the
user
| to clear down the w/sheet each time prior to using the w/sheet,whilst
| protecting the LOOKUP cells. In protecting the worksheet the button also
| appears to be protected and not accessible to the user.
| Can anyone suggest an answer to my problem
| Thank you