Disabling Save

[Edgar]

Hi Guys

Is it possible to Disable the Save feature in Excel
through code while a wb is open and then to turn it off
again when the user closes the wb?

TIA

 

[Frank Kabel]

Hi
not bullet proof but you may put the following code in your workbook
module (not in a standard module)


Private Sub Workbook_BeforeClose(Cancel As Boolean)
appplication.EnableEvents = False
Me.Save
appplication.EnableEvents = False
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub


this won't allow saving a workbook until it's closed