Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to use controls when sheet is protected
Take the sheet out of design mode.
When you protect the sheet, don't select objects as one of the things to protect. -- Regards, Tom Ogilvy "Kirk" wrote in message ... I have a spreadsheet that uses Combo Boxes and Command controls. When the spreadsheet is protected, the user is unable to do anything with the controls. I unprotected the sheet, and the controls go into Design Mode. I can't seem to figure out why the controls won't work. Any ideas as to why this is? Any help would be appreciated. Thanks. Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to use controls when sheet is protected
Not sure what bearing that has on using the controls.
-- Regards, Tom Ogilvy "Kirk" wrote in message ... Current Protect Sheet Settings allow the user to "Select locked cells" and "Select Unlocked cells". Which all of the controls are Locked. Kirk "Tom Ogilvy" wrote: Take the sheet out of design mode. When you protect the sheet, don't select objects as one of the things to protect. -- Regards, Tom Ogilvy "Kirk" wrote in message ... I have a spreadsheet that uses Combo Boxes and Command controls. When the spreadsheet is protected, the user is unable to do anything with the controls. I unprotected the sheet, and the controls go into Design Mode. I can't seem to figure out why the controls won't work. Any ideas as to why this is? Any help would be appreciated. Thanks. Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to highlight an unprotected cell on a protected sheet. | Excel Worksheet Functions | |||
Unable to access unprotected columns on a protected sheet....somet | Excel Discussion (Misc queries) | |||
how to activate controls in protected sheet | Excel Worksheet Functions | |||
Unable to see Properties in Design View for controls | Excel Worksheet Functions | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel |