Copy protection


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?



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:

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

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