ExcelBanter - close code

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

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

- - close code (https://www.excelbanter.com/excel-programming/340599-close-code.html)

Shawn

close code

I need a code that will close the active workbook and save it without giving
you any of the pop-up boxes that autimatically "pop-up" asking you if you
want to save etc.

--
Thanks
Shawn

Tom Ogilvy

close code

Activeworkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Shawn" wrote in message
...
I need a code that will close the active workbook and save it without
giving
you any of the pop-up boxes that autimatically "pop-up" asking you if you
want to save etc.

--
Thanks
Shawn

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