Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I inserted a couple of checkbox objects (from the Form toolbar) in a
worksheet and would like for them to be accessable by other users when the worksheet is protected. When I right-click the object and select Format Control, then the Protection tab, I make sure Locked and Locked Text are unchecked before protecting the worksheet. Unfortunately, when a user attempts to click on the checkbox (within the protected worksheet), they are greeted by the following pop-up message: "The cell or chart you are trying to change is protected and therefore read-only. To modify a protected cell or chart, first remove protection by using the Unprotect Sheet command (Tools menu, Protection submenu). You may be prompted for a password." I have unsuccessfuly Googled this dilemma and hope somebody will be able to help me. Thank you, in advance, for any help you are able to provide. Regards, OMMBoy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I use open/close Grouped cells in a Protected Worksheet? | Excel Discussion (Misc queries) | |||
Sorting a protected worksheet in Excel 2003 | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Insert comment in protected worksheet | Excel Worksheet Functions | |||
Using a cell reference to refernce worksheet in another work book | Excel Worksheet Functions |