ActiveWorkbook.Close

[dallas]

Hi

Sub stang()
ActiveWorkbook.Close
End Sub

Is it possible to close the Workbook without get the question
if you want to save the Workbook or not?


Regards
dallas

 

[Ron de Bruin]

Hi

ActiveWorkbook.Close True ' false = not save and true = save

 

[Tom Ogilvy]

Sub stang()
ActiveWorkbook.Close SaveChanges:=False
End Sub

or change it to True if you do want to save changes.