Protect validation but allow drop down selection

P

Paul07

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 copy>paste and the validation settings for the
copied cells are added to the pasted cell.

Any help?

Cheers
 
E

Eduardo

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
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Customise drop down list validation 3
Data Validation List (Drop Down) Not Showing 2
Data Validation Error 1
Preventing copy/paste on validated cells 2
Copying a Drop Down Menu 2
Copy dropdown list 1
Size of drop down in validation list 2

Top