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

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

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
.

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

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