Call Workbook_BeforeClose
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.
|