Workbook_BeforeSave Event

[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

 

[Jacob Skaria]

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

 

[Barb Reinhardt]

I did both a save and a saveas and the SaveAsUI showed TRUE for both. It
shouldn't have?

Barb Reinhardt

 

[Jacob Skaria]

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

If this post helps click Yes