#1   Report Post  
Pam C
 
Posts: n/a
Default 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,
  #2   Report Post  
Nick
 
Posts: n/a
Default

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,



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel macro to update visio orgchart Anna Excel Discussion (Misc queries) 0 April 29th 05 12:38 PM
How can I edit cell contents with a macro in Excel? Mind the gaps! Excel Discussion (Misc queries) 2 March 23rd 05 09:51 PM
Problem Editing Macro in Shared Excel File [email protected] Excel Discussion (Misc queries) 0 March 19th 05 07:01 PM
Assign Macro to button in Excel doesnt work Any ideas? Mike@Becketts Excel Discussion (Misc queries) 2 December 20th 04 03:47 PM
Macro not working with Excel 2003 Fernando Gomez Excel Discussion (Misc queries) 1 December 16th 04 01:19 AM


All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"