Security for Excel document

[aurelius89]

I need to make my document as secure as possible (With VBA as well)

I will be distributing it out to users, but nothing is stopping them from taking it and walking out the door and giving to someone else.

Although I know Excel isn't the most secure and isn't meant to, but I want to make it as difficult as possible for them.

My ideas are
- Password protect VB editor
- Password protect each sheet
- Disable save, save as, save and send or any other way that a copy of the file could be made from within Excel
- The document itself as an RDP from a server which can be controlled then by Active Directory

So my question is 2 part really, what else can I do?

and what VBA would be needed to completely disable the features I have mentioned?

Thanks

 

[Fluff]

Hia
You can also protect the workbook, which should prevent someone from copying a sheet to a new workbook.
To prevent saving try this

Sub Workbook_BeforeClose(Cancel As Boolean)
     
     ActiveWorkbook.Close savechanges:=False
     
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

    MsgBox "Sorry - But this Workbook cannot be saved"
    Cancel = True

End Sub

BUT this will prevent anyone from saving

 

[aurelius89]

Hia
You can also protect the workbook, which should prevent someone from copying a sheet to a new workbook.
To prevent saving try this

Sub Workbook_BeforeClose(Cancel As Boolean)
     
     ActiveWorkbook.Close savechanges:=False
     
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

    MsgBox "Sorry - But this Workbook cannot be saved"
    Cancel = True

End Sub

BUT this will prevent anyone from saving

Thanks I have got these working fine.

I have also followed the guidance at the bottom of this thread to create custom UI to stop the save and send:

Disable 'Send' in Excel 2007

 

[aurelius89]

Thanks I have got these working fine.

I have also followed the guidance at the bottom of this thread to create custom UI to stop the save and send:

Disable 'Send' in Excel 2007

Although this might sound like a silly question, but how do I save the changes to the VBA (The inclusion of the VBA to disable saving) now that I have disabled saving?

 

[Fluff]

you need to disable macros, then open the workbook, add the macros, save the workbook & then re-enable macros