preventing users copying over

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

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

Preventing users copying over data validation | Excel forum

resolvedResolved · High Priority · Version 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:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips


Server loaded in 0.08 secs.