macro to close excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Disable Macro Alert 2
Excel 2003 + script to open and automatically close an excel workb 1
Excell 2000 macro will not open file! 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
problem with macro setting 1
How to run a macro automatically when the file is opened? 1
Macro - Excel 2003 3

Back
Top