Getting rid of personal.xls

[Gregg]

I made this mistake of saving a macro to the
personal.xls. Now I've deleted the macro (no longer
needed) and still have personal.xls that pops up and gets
in the way everytime I want to use Excel. It is a royal
pain. How can I permananently delete it ?

Thanks.

 

[Brian]

Don't delete it - hide it. You may still need it another time.

With personal.xls open, just use go to Window | Hide.

 

[Don Guillett]

First of all, it should be HIDDEN. If you really want to delete use windows
find to look in all files, including system & hidden. Delete it.

 

[Celtic_Avenger]

Has Excel saved the Personal.xls file in the autosave fil
location.....I think if you delete that, the problem will stop.

Celtic_Avenge

 

[Celtic_Avenger]

Find the file......most probably hidden as said.......dont hide it a
excel will still find the file even if it is hidden.......move to
secure location for future use if needed.

Celtic_Avenger

 

[Gord Dibben]

Gregg

You can hide it when it is open by going to Window>Hide and saving as such.
It will open in the background and not bother you.

If it has nothing in it, you could also delete it if you choose. You can
re-create at any time by recording a macro to "Personal Macro Workbook".

Gord Dibben Excel MVP