Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

preventing users copying over

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Preventing users copying over data validation

Preventing users copying over data validation

ResolvedVersion 2003

Colin has attended:
Excel VBA Intro Intermediate course

Preventing users copying over data validation

I am using a spreadsheet that has a number of cells where data needs to be input by the user. Many of these have data validation set to a list to ensure the data input is correct. However, it is all too common that data is copied and pasted into the cell containing the validation rather than selecting an entry from the validation list. This replaces the cell containing the validation and allows any value to be input. Is there a way to ensure that the cell cannot be copied over but the data from the validated list can be selected?
My attempts to protect cells in the worksheet to prevent data being copied and pasted over the validated cell have meant that no data can be entered into the cell regardless of whether it is selected from the withinn the data validation list.

RE: Preventing users copying over data validation

Hello
The following web site might help you: http://www.j-walk.com/ss/excel/tips/tip98.htm
regards

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.