Close Workbook without displaying message to Save

V

Vinay

Hello:
I have a User form with a button labelled "CLOSE" which closes the
form as well as Quits the application. How I can prevent the Excel
Message which ask whether the user wants to save the file?
I would like to close the file without saving

TIA
 
F

Frank Kabel

Hi
try
application.displayalerts=false
activeworkbook.close
application.displayalerts=True
 
Top