If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Protecting Sheets with drop down boxes
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. |
#2
|
|||
|
|||
Protecting Sheets with drop down boxes
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 "Dolores Gomez" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|