Security in Document Control

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Hi experts,

Could you tell me what facility Excel has for document
control. I am aware of sheet protection and passwording
etc but is there any way of doing the following:

1. Making the file unsavable (even with a different file
name) so changes can be made, printed out and submitted for
inclusion in the master file.

2. Having the file self delete after a certain period of time.

I just only want one copy of this file in existence, bar
backups.

thank you

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

If SaveAsUI = True Then
MsgBox "Restriction on FileSaveAs location!", vbCritical
Cancel = True
Exit Sub
End If

End Sub

there is no way to prevent someone from copying this file from th
explorer. this macro will only prevent saving it at another location o
another file from within excel.

mac
 
Back
Top