Macro / close a workbook without saving

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

i am trying to add some code that will close an open
workbook without saving the changes to it.

thank you for you help.
 
Carl,

This line of VBA code closes the active workbook
without saving it.

ActiveWorkbook.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

Close all without saving and exit without prompts 8
Need VB formula to exit workbook 1
Vba - Save but don't close 3
How can I suppress the enable macros and save changes messages? 4
Excel Providing user message when RED X clicked & properly closing application. 2
trouble with closed workbook 2
Disable Macro Alert 2
Workbook causes calculation errors 2

Back
Top