ExcelBanter - Disable Excel Program Messages

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

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

- - Disable Excel Program Messages (https://www.excelbanter.com/excel-programming/344670-disable-excel-program-messages.html)

Alan

Disable Excel Program Messages

Thanks to MVP's from this site I have code that opens and amends and excel
spreadsheet, however when it makes to cloe it gives me the 'Save Changes'
Yes, No, Cancel' Option ... Is there a method to automate yes and disable
this messagebox ??

Many Thanks again

Tom Ogilvy

Disable Excel Program Messages

ActiveWorkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
Thanks to MVP's from this site I have code that opens and amends and excel
spreadsheet, however when it makes to cloe it gives me the 'Save Changes'
Yes, No, Cancel' Option ... Is there a method to automate yes and disable
this messagebox ??

Many Thanks again

Alan

Disable Excel Program Messages

Tom

Thanks very much ... your assistance is appreciated

"Tom Ogilvy" wrote:

ActiveWorkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Alan" wrote in message
...
Thanks to MVP's from this site I have code that opens and amends and excel
spreadsheet, however when it makes to cloe it gives me the 'Save Changes'
Yes, No, Cancel' Option ... Is there a method to automate yes and disable
this messagebox ??

Many Thanks again

All times are GMT +1. The time now is 05:10 PM.