Exit Workbook_BeforeClose(Cancel As Boolean) if a public boolean = true

[meabrams]

I have macros that run in Workbook_BeforeClose(Cancel As Boolean) I want to exit if a public Boolean equals true. The Boolean is to be set by any one of the macro that is called but I am not able figure out how to terminate the Workbook_BeforeClose(Cancel As Boolean) and stop it from closing excel.

Thank you for any and all of your help
Bramz

[cytop]

In the Workbook_BeforeClose event handler, just set the parameter 'Cancel' to the value of your public var.

Please Login or Register  to view this content.

If varName is True, then Cancel is set True and the workbook will not unload.

[meabrams]

That was almost to easy thank you for your help

Bramz