Workbook_BeforeSave Event

  • Thread starter Thread starter Barb Reinhardt
  • Start date Start date
B

Barb Reinhardt

I want to do some other actions when I do a "SAVEAS". Can someone remind me
how to capture that in the BeforeSave event?

Thanks,

Barb Reinhardt
 
Hi Barb

In the below workbook event SaveAsUI will return True

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

If this post helps click Yes
 
I did both a save and a saveas and the SaveAsUI showed TRUE for both. It
shouldn't have?

Barb Reinhardt
 
You must have tried that in a unsaved workbook..Try that in a saved workbook.

If this post helps click Yes
 
Back
Top