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" <(E-Mail Removed)> wrote in message
news:764A4CE2-4B53-49C8-BD86-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:764A4CE2-4B53-49C8-BD86-(E-Mail Removed)...
> > I need to call Workbook_BeforeClose from a standard code module in the
> same
> > file...what is the syntax to do this?
> >
> > Thanks.
>
>
>