ExcelBanter - How do I have excel not promt me to save when I close a document?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I have excel not promt me to save when I close a document? (https://www.excelbanter.com/excel-programming/357043-how-do-i-have-excel-not-promt-me-save-when-i-close-document.html)

Precise Eng

How do I have excel not promt me to save when I close a document?

I don't want excel to promt me to save my document when I close it. Any ideas?

Tom Ogilvy

How do I have excel not promt me to save when I close a document?

ActiveWorkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy

"Precise Eng" wrote:

I don't want excel to promt me to save my document when I close it. Any ideas?

Gary Keramidas

How do I have excel not promt me to save when I close a document?

programmatically?

Workbooks(Filename).Close SaveChanges:=False

--

Gary

"Precise Eng" wrote in message
...
I don't want excel to promt me to save my document when I close it. Any ideas?

All times are GMT +1. The time now is 01:57 PM.