Get Excel 2007 to close completely after creating a macro in the personal macro workbook

"If you have deleted all the macros from the personal macro workbook, you can delete the file PERSONAL.XLSB. This should cause Excel to stop doing what you described.

The file should be in one of:

C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB

or

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

or

C:\Program Files\Microsoft Office\Office\XLStart

or similar, depending on Windows version, etc."

One more solution: click on the 'Office Button' in the upper left hand corner of your screen - right click on 'Exit Excel' - then choose 'Add to Quick Access Toolbar'. This will place an 'X' on your toolbar which only needs to be clicked once to close Excel completely.