Protection from copying
 

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

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.
--
Earl Kiosterud
www.smokeylake.com

"ZTamsen" wrote in message
...
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

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



"ZTamsen" wrote in message
...
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