Close File

  • Thread starter Thread starter FRANKB
  • Start date Start date
F

FRANKB

At the end of my VBA statement I have ACTIVEWORKBOOK.CLOSE.

I still get the message asking whether I want to save or
not. What do I have to add to my statement in order to
not get this message.

Thanks
Frank
 
Frank,

Just before that line of code, use:
Application.DisplayAlerts = False

or
fool the workbook into thinking that it's already saved:
Activeworkbook.Saved = True

John
 
Back
Top