Detect Save or Save As Event in Excel to run a macro. 1

[Goska]

I think the subject was descriptive enough of my question. I want to be able to intercept a Save or SaveAs that the user is trying to do from the File menu for a portion of my program, so they don't try to overwrite the main file that I have. Thanks in advance.

 

[segmentationfault]

In the ThisWorkbook object, use the following event:


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

If (you want to forbid saving) Then
Cancel = True
End If

End Sub

 

[Goska]

Perfect. I had been playing with that same code from the help files and just couldn't get it quite right. Thanks.