I have created a template in MS Excel 2000 that will be put on a server for several users to input data into a database.
The cells in which users will enter data have data restrictions created using data validation.
I have protected the worksheet so that "validation" is greyed out on the data menu, so users cannot change the restrictions that way.
However, this does not prevent people from accidentally changing a cell's restrictions by copying another cell's contents and pasting onto the cell with the restrictions. Copying and pasting has the effect overlaying the restrictions of the cell being pasted into with whatever restrictions the copied cell has.
Does anybody know how I can prevent that from happening?
Note: I have also gone to tools-->options, then have unchecked "allow cell drag and drop," which at least will prevent users from dragging one cell's data restrictions over another, although it will not prevent pasting over them. This made me wonder: is there a way I can disable the paste function so users simply do not having the option of pasting?
Thanks for reading this (and hopefully having an answer...)
This question was answered on April 6, 2003. Much of the information contained herein may have changed since posting.
About the author
Posted by ricardo of Katharine Gibbs School - New York on April 6, 2003
Need Help with this Issue?
We help people with technology! It's what we do.
Contact or Schedule an Appointment with a location for help!