View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Finance Guru Finance Guru is offline
external usenet poster
 
Posts: 83
Default 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