Suppress Save Dialog on Before Close event

[elmonko]

Hi,

I have a command button code on a sheet that checks if all the cells in a table have been completed before saving the worksheet. If they're not all complete a userform message box pops up with a reminder then returns to the sheet without saving. I want to be able to call this from the 'BeforeClose' event as well however, even though it still does what it's supposed to do, after the userform message box has displayed and been unloaded then it still pops up the Save Dialog box.

I'm struggling to suppress the Save Dialog box and return to the sheet.

I can post the code if need be however I'm not where the workbook is saved whilst posting!!!

 

[tweedle]

Hi elmonko.

Do you see the 'Cancel' in
Private Sub Workbook_BeforeClose(Cancel As Boolean) ?

Set that to True inside the Workbook_BeforeClose procedure.

i.e. Cancel = True