excel doesn't close because of personal macro workbook

Hi,

I have this problem where I created some macros saved in a personal macro workbook. Excel 2007.

And ever since, I can never close excel. I close the spreadsheet. Excel is still open but empty. I have to close it one more time to actually close. This is because of the hidden personal macro workbook.

How do I get around this?

Also, where can I find my personal macro workbook... on Vista... I tried searching, but can't find it anywhere. It has important macros and I would like to back it up.

thanks.

In XP, Personal.xls is in C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLStart\ If it's not there in Vista, do a file search.

thanks, i found it in xlstart after I searched for it.

about my main question... I guess this is an annoyance I will just have to live with?

No. How did you create personal.xls?

dunno, excel did it automatically... but i think extension might be .xlsb

I just recorded some macros... then I edited the macros by hand.

Try this (from http://www.rondebruin.nl/personal.htm)

What to do if your PERSONAL.XLS(B) is visible

When you open Excel and you see PERSONAL.XLS(B) in the title bar you can use this to hide it.

Excel 2007: On the View tab in the window group choose Hide. Then close Excel and say Yes to save the changes to your PERSONAL file.

thanks but my problem is only as described in the first post. My personal xlsb file is hidden, I cannot see it anywhere.

Outta ammo, sorry.

np, thanks for the effort