Protection from copying

Z

ZTamsen

I have a workbook with hidden cells that I would like to protect (leaving
certain cells visible for input). However, even with password protection on
the entire workbook, a user can copy all of the cells into another workbook
and view/edit/change all of the cells in my workbook. Is there a way around
this?

thanks
 
E

Earl Kiosterud

Z,

If it's formulas you want hidden, use Format - Cells - Protection - Hidden.
Then protect the sheet (Tools - Protection - Protect sheet). If it's data,
forget it. Users can copy/paste cells , copy the sheet, take a picture of
the workbook with PrtScrn (or with a camera if they're really determined),
and use OCR to easily get the data.

When you say password protection, that can be at many places.
 
H

Henry

ZTamsen,

You could use a Userform for input.
If you make the form full screen, your users need never see the spreadsheet.
By disabling the control-break and close methods and only allowing closing
the form from a button on the form, your users can never see the
spreadsheet.

Henry
 
Top