MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Unlocking Combo Box (from Form toolbar) so usable when sheet is protected.


Posted by Laura Westgate on November 23, 2001 1:40 AM

In format control of the combo box, I have de-selected the 'locked' checkbox. Then protected the sheet. However, I am unable to change values in the drop down. How can I unlock this control??


Posted by Ivan F Moala on November 23, 2001 5:31 AM

unlock the linked cell (NT)

Posted by Paul Akkermans on November 23, 2001 5:37 AM

Unlock the input cells also (Format->cells->protection->locked)