Excel Information Security

[allenht]

Greetings,

I have an excel workbook that I have been working on for quite some time at work. It is important that I allow other members of the network to use it. To protect sensitive information, I have protected each sheet with passwords. I have also hidden a great deal of information within the file and I keep the document in read only mode so that no one changes any information.

I am concerned because I do not know how to keep someone from saving a copy of the workbook through save as. While I have tried to protect the workbook as best I know how, I am still vulnerable to a disgruntled employee saving a copy of the file and then emailing to whomever. Is there anyway to disable saving a copy of an excel file to prevent the document from leaving the company? While saving a copy will not allow any end user to get to my hidden content I do not want any unauthorized user accessing even the parts that are not hidden.

In need of some peace of mind!
allenht

 

[Armando Montes]

Here are two options:
http://www.mrexcel.com/forum/showthread.php?t=79470

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then Cancel = True
End Sub
 
Sub disblesaveas()
CommandBars("File").Controls("Save As...").Enabled = False
End Sub

 

[Ruddles]

Is there anyway to disable saving a copy of an excel file to prevent the document from leaving the company?

How will you stop them simply copying the file to a USB stick using Windows Explorer? Or right-clicking the filename in Windows Explorer and going Send To > Mail Recipient?

Also, you can only use VBA if macros are enabled to start with.

 

[RoryA]

Your workbook/worksheet protection is worthless against someone with even a modicum of determination, by the way.

 

[allenht]

I really don't know. The only thing I have thought of is to keep the source file in the shared files and hide it. I've created shortcuts to the document for them so that no one can easily get to the source document. No one has access to Windows Explorer and Thumbdrives have been disabled on the network.