Call Workbook_BeforeClose

[Guest]

I need to call Workbook_BeforeClose from a standard code module in the same
file...what is the syntax to do this?

Thanks.

 

[Peter T]

Dim b As Boolean
Call ThisWorkbook.Workbook_BeforeClose(b)

Ensure Workbook_BeforeClose is Public and not default Private

Why not let your BeforeClose event call a procedure in an ordinary module,
the same procedure can be simply called from elsewhere

Regards,
Peter T

 

[Guest]

Even easier (not much but it seems easier to me) is to just use Auto_Close.
Try

Sub Auto_Close()
MsgBox "Tada"
End Sub