Combo Box/Worksheet Protection Conflict

[Guest]

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

 

[Chip Pearson]

Phil,

Can't you just unprotect that cell?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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?

 

[Stephen Nyikos]

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

 

[Chip Pearson]

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


message
news:[email protected]...

 

[Guest]

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