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
|