Results 1 to 2 of 2
Thread: Non-copyable Sheet (Excel 2000)
2004-02-24, 18:47 #1
- Join Date
- Mar 2003
- Thanked 0 Times in 0 Posts
Non-copyable Sheet (Excel 2000)
Is it possible to make a sheet non-copyable, both content and format ? (can view and print, but not copy).
2004-02-24, 19:26 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: Non-copyable Sheet (Excel 2000)
Not sure all the things you are trying to protect.
These suggestions will make it more difficult, but not impossible to copy:
Protect the workbook (tools - protection - protect workbook) will "prevent" selecting the sheet to copy the sheet as whole
Add this code to the sheet object in VB
<pre>Private Sub Worksheet_Deactivate()
Application.CutCopyMode = False
If you select cells in the sheet, this will clear the xl clipboard (when you select another sheet) so you can not paste to another sheet.
Note you could still copy and paste to a different program (it only clears the xl clipboard)
Another trick (does not require a macro) is to keep all the data on a hidden sheet. the use the Camera tool to paste an image of the hidden sheet. Then protect the sheet with the image (tools - protection - protect sheet). Now they can not select the picture so no copying. If you have nothing in the other cells there is nothing for them to copy.
Note: they could still <print screen> to the clipboard and paste the IMAGE in another program, so I would assume this is not a big issue since you allow them to print it anyway.