preventing users copying over
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Preventing users copying over data validation

resolvedResolved · High Priority · Version 2003

replyReply Wed 14 May 2008, 11:30Delegate Colin said...

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.

For upcoming training course dates see: Pricing & availability

replyReply Thu 15 May 2008, 20:09Trainer Cress said...

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

 

Please browse our web site to find out more about
excel one day course london and other Microsoft training courses.

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard