ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I protect my Excel workbook against copying ? (https://www.excelbanter.com/excel-discussion-misc-queries/94661-how-can-i-protect-my-excel-workbook-against-copying.html)

Kris Van Quickenborne

How can I protect my Excel workbook against copying ?
 
I have protected my worksheet with a password on the sheets, and saved it as
read only. Still anyone can copy the data from the sheets to another blanc
sheet. What do I have to do to protect my worksheet against beeing copied ?

Dave Peterson

How can I protect my Excel workbook against copying ?
 
You can lock the formula cells on the worksheet and when they're copied and
pasted, the copier will see values--not formulas.

But worksheet protection is really simple to break. There's really nothing you
can do to stop copy|pasting of your data.

Kris Van Quickenborne wrote:

I have protected my worksheet with a password on the sheets, and saved it as
read only. Still anyone can copy the data from the sheets to another blanc
sheet. What do I have to do to protect my worksheet against beeing copied ?


--

Dave Peterson


All times are GMT +1. The time now is 03:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com