Then record a new macro and have it saved in personal.xls. Save personal.xls
and close excel and reopen.
Did excel find that version?
If yes, then use windows|Find|Files or folders to find that new personal.xls and
replace it with your real one.
I could do this inside the VBE. Hit ctrl-G to see the immediate window and type
this and hit enter:
It returned this for me (xl2002 and win98):
If it still doesn't work, xl2002 can "quarantine" a file. Maybe the user got
prompted with a message that personal.xls was corrupt and then excel asked if it
should never open that file again.
You can reverse this under:
Help|About Microsoft Excel|and click on Disabled Items
And you don't have any funny macros that close the file if everything isn't ok,