Copy protection


P

Paul Tugwell

I have a spreadsheet that I wish to protect so that its contents can be
viewed but not altered or copied by the recipients. I have set passwords for
the worksheet and the workbook and against the modify in tool options.
However it is still possible to select the entire contents of a sheet and
copy them to another workbook where they are unprotected! Is there any way
of stopping this?
 
Ad

Advertisements

J

JE McGimpsey

It's worse than that. XL's internal protection is suitable for
preventing inadvertent modification of the workbook.

In addition to the copy/paste workaround, the other steps you've taken
already are trivial to bypass:

http://www.mcgimpsey.com/excel/removepwords.html

In brief: If someone with the wit to draw breath can access your
workbook, they can access everything in it.

One alternative would be to compile your logic and fixed data into a COM
add-in.

Or perhaps you could send a pdf?

That also won't prevent copying, of course.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top