Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect validation but allow drop down selection
Hi
I would like to allow users of my spreadsheet to select from a drop down list in cells but would like to prevent changes to the validation settings for the cell. I am finding that people copypaste and the validation settings for the copied cells are added to the pasted cell. Any help? Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect validation but allow drop down selection
Hi,
you can protect your workbook not allowing anybody to change you validation settings. you can give access to the whole spreadsheet but the validation. Highlight all the cell you want the user to enter information, right click in the mouse, format cells, Protection, uncheck locked, be sure that your validation list is locked, then protect the sheet if this helps please click yes, thanks "Paul07" wrote: Hi I would like to allow users of my spreadsheet to select from a drop down list in cells but would like to prevent changes to the validation settings for the cell. I am finding that people copypaste and the validation settings for the copied cells are added to the pasted cell. Any help? Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
protect cells after listbox selection | Excel Discussion (Misc queries) | |||
drop down selection determines other drop down content | Excel Discussion (Misc queries) | |||
How can you jump to a selection in a validation drop-down? | Excel Worksheet Functions |