Hi,
I have a userform (aCloseDown) on workbook_beforeclose that opens when the upper right corner X is clicked to close the workbook. When Label1 (a yes close workbook button) is clicked the userform closes and the macro in workbook_beforeclose runs and the workbook then closes. That works great. I want to make Label2 a cancel button, so if it is clicked the userform closes, the macro in workbook-beforeclose does not run, and the workbook stays open.
Is a cancel type of button this way possible?
Userform code...
Workbook_beforeclose code...
Bookmarks