Supress Save File Message when exiting Excel file 1

[jpkeller55]

Does anybody know if there a way to suppress the message "Do you want to save the changes you have made to FILENAME" in Excel when you exit the file?

Thanks...Jim

 

[PHV]

If you DON'T want to save the changes:
ThisWorkbook.Saved = True
ThisWorkbook.Close

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jpkeller55]

That works perfectly...Thanks PH