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

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