I have a form with a few drop-down list. In order to protect all other content, I protected the sheet, allowing the user to select unlocked cells, and I unlocked all fields and drop-down controls. However, while the fields can be selected and modified, the controls can be selected, the drop-down list appears, but when we do a selection, it states the cell or graphic is in read-only. How can I ensure the user can change the selection of this list when the sheet is protected?
Thanks!
Annie
Bookmarks