Disable Paste

  • Thread starter Thread starter TripleT
  • Start date Start date
T

TripleT

Hi

I have a spreadsheet with a range of cells that I do not want people t
paste information into. We are using Excel 97, but moving to 2003 nex
year.

I've tried using validation to limit what people can enter into th
cells, but the problem is people can paste over the top of th
validation to get around it.

Is there a solution for this?

Cheers, Triple
 
TripleT > said:
If anyone is interested it is at this site:

http://www.asaputilities.nl/scripts/tips/tips.php?detail=2001-09-05_9997263
Click to expand...
63.tip

This'll work against naive users, but ignoring anyone who knows how to
execute the statement Application.EnableEvents = False this solution
doesn't mask [Ctrl]+[Insert], [Shift]+[Insert] or [Shift]+[Delete]. Or for
that matter, if your validated cells accept blank entries, entering ="",
then Edit > Replace ="" with any darn thing they feel like.

Robust validation is *only* provided by Change and Calculate event handlers
with the validation criteria built into them. There's no practical way to
make lightweight Data > Validation robust. Even then, there are the nastier
users who do know how to execute the statement Application.EnableEvents =
False , and there's nothing you can do to stop them.

The oldest and still *BEST* way to get valid inputs from users is to assure
them they'll get immediately obvious GARBAGE OUT if and when they enter
GARBAGE IN. That means building many formulas to return 0 or "" when inputs
are valid, or various errors (#NULL!, #VLAUE!, #NUM!) when inputs are
invalid along with diagnostic messages displayed by formulas telling them
the garbage they see is their own fault.
 
Back
Top