MrExcel Publishing
Your One Stop for Excel Tips & Solutions

copy, save-as disables

Posted by Dana Owens on January 26, 2002 8:19 AM

I have created a data base in Excel that has some usful information in it. I want to send it one person via intra-company e-mail. but, I do not want to be copied or saved as another document and sent out to the public domain.

Is there a way to protect this data from being copied, saved as, or sent on to a second destination?

Any ideas? even if it is outside of Excels capabilities.

Posted by Tom Urtis on January 26, 2002 9:46 AM

There are no guarantees. If someone wants to copy your data they will find a way to do it.

To stop your friends, try this: Right click on the sheet tab icon (just to the left of the "File" menu option near the upper left corner of your screen), and left click on View Code. Paste the following 3 events in:


Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Application.CutCopyMode = False
End Sub

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
Application.CutCopyMode = False
End Sub

Private Sub Workbook_Deactivate()
Application.CutCopyMode = False
End Sub


Now, lock & password protect the VBE Project so no one can delete the code.

Did I mention there are no guarantees? Don't want to sound flip, just don't want to give a false sense of security that this will stop everyone all the time.

Good luck.

Tom Urtis