ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro to close excel (https://www.excelbanter.com/excel-discussion-misc-queries/24970-macro-close-excel.html)

Pam C

macro to close excel
 
If I have a macro to automatically run a macro when the workbooks opens, what
do I add to make Excel close after the macro finishes running.

Thanks,

Nick

Thisworkbook.Close <true/false/blank

Followed by True to save the changes or False to save with out changing.
Leave blank after and excel will prompt you.

Nick

"Pam C" wrote in message
...
If I have a macro to automatically run a macro when the workbooks opens,
what
do I add to make Excel close after the macro finishes running.

Thanks,





All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com