Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am creating an excel document with Forms Checkboxes in it. I've unlocked
the forms checkboxes, as well as unlocking the all the cells both within the checkbox area as well as all around the checkbox area. When I protect the spreadsheet, I've checked only the "allow users to: select unlock cells, edit objects"; I've also tried using those two options as well as "edit scenarios". I keep getting an error message stating that the "cell or chart is protected....and read only". How do I protect cells and the spreadsheet while still allowing a forms checkbox to be checked or unchecked without receiving the error message? I also wouldn't even begin to know how to write a macro for this (or how to access them) if this is what is needed. (If at all possible, I'd like to stay with the forms checkboxes, as they appear better when printing the spreadsheet.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forms Checkbox | Excel Discussion (Misc queries) | |||
Click event for checkbox from Forms toolbar | Excel Discussion (Misc queries) | |||
How do I resize the actual Forms checkbox | Excel Discussion (Misc queries) | |||
EXCEL FORMS CHECKBOX | Excel Worksheet Functions | |||
protection on excel forms | Excel Worksheet Functions |