Stop Event

[Guest]

I have written a workbook_beforeclose procedure that checks if data had been
entered into a cell. At times, I do not want it to run when I close the
workbook. So I create a button with a simple code of "Application.Quit",
hoping that it would bypass the workbook_beforeclose. But it does not work.
Can anyone tell me how to by workbook_beforeclose procedure when I close the
workbook?

 

[Guest]

Create a non-Event macro to simply disable events. Run this macro and then
close

 

[Gord Dibben]

Sub Disable()
Application.EnableEvents = False
End Sub


Gord Dibben MS Excel MVP