Global Sheet Protection and a Button
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
|