Name of File.xls: Disable Save

Hello!

Is there a piece of code that I can use that will stop the following warning message from appearing when I hit the X button?

"Do you want to save the changes you made to 'Name of File.xls'?

Thank you

ThisWorkbook.Saved = True

will tell (lie to) the machine that it has been saved, so it won't ask you.

Hi There,

Always glad to try and help a fellow Aussie!!

The following code should do the trick:

Sub Auto_Close
ActiveWorkbook.Close SaveChanges:=False
End Sub

HTH

Robert

Thank you both very much!