Programatically close a file without saving

  • Thread starter Thread starter vvaidya
  • Start date Start date
V

vvaidya

Hello:
I need to be able to close a file programmatically, but when I try to
do so the Excel message: "Do you want to save the changes that you made
to ---" With the choices "Yes", "No" and "Cancel" comes off & I would
like to close the file without saving it.
I would appreciate help wit the above.

TIA
Vinay
 
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
End Sub

Gord Dibben Excel MVP
 
You could also use one of these:

ThisWorkbook.Close SaveChanges:=False

or

Application.DisplayAlerts = False

Regards,
KL
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

closing file without saving 1
File closes without prompt to save!!! 3
How to Extract Emails from PST File Without Outlook? 2
Closing temp worksheet without saving 4
Macro to Close Workbook Without Save Any Changes Made 4
explicitly name workbook and close without saving 2
Formats: Too many different cell formats error message 3
Macro to SAVE and EXIT from EXCEL 2

Back
Top