How do I get excel to close completely after creating a macro in a personal workbook?

Posted by Greg B on Super User See other posts from Super User or by Greg B
Published on 2010-03-22T22:03:48Z Indexed on 2010/03/22 22:11 UTC
Read the original article Hit count: 463

Filed under:
|

I am using Microsoft Excel 2007 and have several macros in my personal.xlsb workbook, which I use often, so it is very convenient that Excel opens them automatically when it starts. What I don't like is when I click on the "X" in the upper right corner of the window Excel does not exit when I close the last visible workbook. I think that this is because personal.xlsb is still open (though hidden). There are several other questions here on Superuser that have people remove personal.xlsb or move it so it doesn't open on startup (question 65297) or change settings to have only one window show in the taskbar (question 86989). (Sorry there are no hyperlinks--apparently I need more reputation to add additional hyperlinks.)

I would like to have personal.xlsb open when I open Excel, have each Excel window show in the taskbar but have Excel exit when I click the "X" on the last workbook that isn't personal.xlsb. Any thoughts on how to achieve this?

© Super User or respective owner

Related posts about excel

Related posts about excel-2007