Protecting Sheets with drop down boxes

D

Dolores Gomez

I have a spread sheet that has drop down boxes with functions and
validations. I want to be able to protect this spreadsheet so that users can
only be able to use the drop down function and not accidently delete the
formula. When I password protect this spreadsheet it will show the drop down
box, however when I click on one of the options it gives me an error and does
not let me select from the list. Is there anyway to protect my spreadsheet
and be able to use the drop down boxes.
 
D

Duke Carey

You simply have to unprotect the cells that have the dropdown validation.
Select all those cells, press Ctrl-1, go to the Protection tab and uncheck
the Locked checkbox
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting sheets with drop down boxes 6
Formatted cell column in drop down list 1
Dependent drop down dynamic range formula, off sheet. 7
Drop Down lists and condtional formating 2
Alt codes 4
Drop Down with dynamic named range offsheet source list 14
Conditional Drop Down boxes 2
Drop Down list predicated on other drop down lists 2

Top