I understand what you are referring to. This is a side-effect of having the
"Show all windows in the Taskbar" option set on under Excel Options,
Advanced, Display. If you can live without this you should turn it off. I
don't know of any other remedy.
--
Jim
How do you know it remains open when Excel is closed? Are you seeing Excel
as a process in your task manager. You should leave personal.xls open
while
you are using excel. On default personal.xls is set to open and close with
excel. If you close it before you are done using excel then you won't be
able to use your macros. If you don't see excel in the task manager then
personal.xls is not open. Hope that helps.
If I open up another workbook (for example "MyWorkbook.xlsx)
"personal.xlsx" is opened behind the scenes. All is great with the
world. When I close out "MyWorkbook.xlsx", "personal.xlsx" is still
open and I can see it. (The window is hidden, but Excel is kept
open. If I only ever had "MyWorkbook.xlsx" open, then if I want to
get out of Excel I have to close things out TWICE, once for
"MyWorkbook.xlsx" and one for "personal.xlsx". That, from a user
standpoint, could be a little annoying. I was wondering if there was
a way around that.