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

Thanks.

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

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

Thanks.

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

Sub Auto_Close()
MsgBox "Tada"
End Sub

--
HTH...

Jim Thomlinson


"Peter T" wrote:

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

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

Thanks.