When you create a macro that you want to use in multiple documents, it creates a new file called personal.xls.
What’s annoying about it, however, is that it now opens personal.xls whenever you open any excel file.
All you have to do to remove it is delete it. Now other settings need to be changed. The trick is locating the file in the first place.
You can often locate it by going to the File > Save As menu and then looking at the path it wants to save it in. It may be that some of the folders in that path are hidden.
On my computer it was located on this path:
C:\Documents and Settings\Default User\Application Data\Microsoft\Excel\XLSTART
Once you’ve found the path, open up Windows Explorer and delete it. You’re done.
I hope this helps someone. It annoyed me for weeks before I decided to get rid of it.