View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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.