Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clearing Check Boxes and Cells
Ok, this is either going to kill me or make me stronger..........
I have successfully combine my "clear" functions into one button now (clearing text/numbers from cells and clearing checks from boxes)................. NOW....... NOW.......... my problem is that when I protect the sheet........ the "clear" button that worked perfectly gives a "Run-time error'1004', Unable to set the Value property of the CheckBoxes class". If I turn protection back off, the button works perfectly. I have to be able to protect the sheet so users can only check boxes and enter text into specific cells.......... Ideas/suggestions?? Thank you!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Macro to clear out check box seletions | Excel Worksheet Functions | |||
Check Boxes | Excel Worksheet Functions | |||
Drop Down Boxes for Validation Cells are Too Wide | Excel Discussion (Misc queries) | |||
Adding Check Boxes | Excel Discussion (Misc queries) | |||
Using a Check Box as a control item | Excel Discussion (Misc queries) |