Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    174
    Thanks
    0
    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).

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    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
    End Sub</pre>


    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.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •