Dialog Box ?

[danenorman13]

Hey All,
I am trying to figure out a code to put at the end of my Macro that will close the workbook without saving if the person presses Cancel in the Save As dialog box that automatically opens. I have the Save As opening but I can not figure out how to add that the Cancel button kills the program.

Any help is greatly appreciated

Thanks
Dane

 

[Tom Urtis]

Enclose that part of the code within

Application.DisplayAlerts = False

'your code


Application.DisplayAlerts = True




You could also invoke the line
ActiveWorkbook.Saved = True