Excel Macro to Close Without Saving

  • Thread starter Thread starter Kass
  • Start date Start date
K

Kass

I'm just starting to learn VBA. I want to make a macro
to close the active window and then not save. I have
template the user uses and then I need it to close and
not save so the template stays intact. I can get the
first part of the macro with ActiveWindow.Close. But
then the save prompt window shows up and I don't know how
to continue the macro so as to answer the prompt
with "NO" so as to close without saving. Thanks for your
help!

Kass
 
Kass,

You're in the wrong NG for Excel!

Anyway, the answer is

ActiveWindow.Close False

Nikos
 
The answer to your question is...

Code
-------------------

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub
 
Back
Top