Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't Get Objects To Work In A Protected Worksheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't Get Objects To Work In A Protected Worksheet
The linked cell must also be unlocked. -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=546038 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't Get Objects To Work In A Protected Worksheet
OMG! How easy was that?! Why didn't I think of that?! Thank you so much
ProtonLeah! If I had spent any more time trying to find the solution on my own, they would've had to commit me! Thanks, again, and have a great weekend! "protonLeah" wrote: The linked cell must also be unlocked. -- protonLeah ------------------------------------------------------------------------ protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097 View this thread: http://www.excelforum.com/showthread...hreadid=546038 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |