Disable Msg box

[hmk]

Hi there
How can get red of this msg when closing a workbook

A Msg appears telling me:
Do yuo want save changes you made?

Thanks
[/quote][/code]

 

[Tom Urtis]

A few ways...

End your macro with the line
ActiveWorkbook.Close False 'to close without saving

or
ActiveWorkbook.Close True 'to close and save

or
ThisWorkbook.Save 'to save

or
ActiveWorkbook.Saved = True 'to make the workbook think it has been saved

or
sandwich the code between Alert settings:
Application.DisplayAlerts = False
'your existing code goes here
Application.DisplayAlerts = True

 

[hmk]

Thank u very much Tom Urtis

yours
h