Dropdown Box & Protection

N

News Reader

I have a worksheet with a dropdown box and other information.

I want to protect the sheet and the workbook from changes, but allow
users to select from the dropdown box, with the looked-up information
being passed to cells on the sheet. After I protect the sheet and the
workbook, I can't make any changes to cells (as expected and wanted),
but I also can't make selections in the dropdown box.

In Format Control, Properties, the Locked option is not checked.

Can I do what I want to do and, if so, how?

Thanks for any help.
 
D

Dave Peterson

Your linked cell has to be unlocked (on a protected worksheet).

You could either unlock that cell (and hide the column or row) and use a formula
to point at it--or even move the linked cell to another sheet (which could be
hidden).
 
Top