Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range name: Change from sheet specific to global | Excel Discussion (Misc queries) | |||
Sheet Protection | Excel Worksheet Functions | |||
Command Button protection problems???? | Excel Worksheet Functions | |||
Sheet Protection | Excel Worksheet Functions | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions |