Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box/Worksheet Protection Conflict
A ComboBox is set up to populate a merged cell range - set up from the Linked Cell and List Fill Range properties. Works okay. However, when the worksheet is protected and the user selects from the ComboBox, an error/warning comes up: "The cell or chart you are trying to change is protected and therefore read-only...." How do I make the ComboBox populate the target cell when the worksheet is protected
Thanks Phi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box/Worksheet Protection Conflict
Phil,
Can't you just unprotect that cell? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Phil Hageman" wrote in message ... A ComboBox is set up to populate a merged cell range - set up from the Linked Cell and List Fill Range properties. Works okay. However, when the worksheet is protected and the user selects from the ComboBox, an error/warning comes up: "The cell or chart you are trying to change is protected and therefore read-only...." How do I make the ComboBox populate the target cell when the worksheet is protected? Thanks, Phil |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box/Worksheet Protection Conflict
If you have control of the password and code, protect your
VBA and do this to unprotect, process, and reprotect: 'make sure you have the correct one showing Worksheet("Sheet1").Activate Worksheet("Sheet1").unprotect ("pass") //code Worksheet("Sheet1").protect ("pass") Be sure the cells protection set to protected. This will need to fire each time a change will ocurr. Call the un/protect method each time the sheet performs an action affecting the cells. Hope that helps, Sn -----Original Message----- Chip, Tried unprotecting both the cells under the ComboBox, and the target cell - same result. Phil . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box/Worksheet Protection Conflict
Phil,
I have no problems using a Forms ComboBox control on a protected worksheet if the Linked Cell is unlocked. What specific problem are you encountering? You can email me the sheet if you want. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Phil Hageman" wrote in message ... Chip, Can you help further on this? Think I lost Steve. Phil |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box/Worksheet Protection Conflict
Chip
You have answered my question - the linked cell was protected. Works fine now I have taken my ComboBox issue to another level in my latest post on programmed ComboBoxes - I was creating a monster with a localized LinkedCell/ListFillRange. The way I was headed, I would have to change 396 worksheets, rather than 33, when the ComboBox parameters changed. If you have time, could you look at this thread Thanks for you time and help Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name Conflict window pops up, when I try to open a saved worksheet | Excel Discussion (Misc queries) | |||
Worksheet protection interfering with data validation combo box pr | Excel Discussion (Misc queries) | |||
Combo box drop down & worksheet protection | Excel Discussion (Misc queries) | |||
combo box protection | Excel Discussion (Misc queries) | |||
Combo Box conflict with 'sort' on another page | Excel Worksheet Functions |