Closing workbook without saving changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to perform some cheks on workbook, afterthis I want to discard the
changes done on the workbook. I want it without input from user.

Thanks for the help in advance
 
Add this to the end of your code
ThisWorkbook.Close (SaveChanges = False)
 
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

Save As and new workbook new name used in existing code 8
Unhide sheet 2
save and exit macro 8
Unwanted workbooks on startup 2
"Do you want to save changes?" question 5
explicitly name workbook and close without saving 2
Close current workbook 1
Saying No to Message Box prompt through VBA 6

Back
Top