How do I protect a worksheet from being copied & pasted?

J

JJ

In Excel 97 I need to send a client a worksheet that I am protecting. But I
don't want them to be able to copy the whole worksheet and paste it into a
blank worksheet and amend that.
 
B

Bryan Hessey

The safest way is to print the item and scan the printed output to
.tif file, then send either the .tif or a .pdf copy of the .tif (no
a .pdf copy of the Worksheet)

The 'Capture' process from Adobe, or a good OCR program will stil
enable copy & paste, but will make it more difficult.

There are very few other ways to prevent the Copy / Paste fro
happening
 
D

Dave Peterson

Once you give them the excel file (or any file), I don't think there's a way to
stop anyone from copying it.
 
S

swatsp0p

JJ: Sounds like you don't trust your client. If this may become
legal matter, also keep a copy of the printout that Bryan suggested an
mail it to yourself. Don't open the letter, rather keep it in a saf
place. Should you ever need it in court, the postmark will verify th
condition of the data on the date you mailed it.

Excel was never designed to be "Secure" and as such there is no sur
way to protect data against undesired editing.

Good Luck!

Bruc
 
Top