Solved: Hide my "Personal"

[rbunc]

I have excel macros stored in "personal.xls" and everytime I run one of the macros, the "personal" spreadsheet shows up. How can I code it out of there or have it never open up. Any help would be greatly appreciated; great answers may just get a pie.

[Bob Phillips]

Store it in the XLSTART directory.

You can find that by typing

?Application.StartupPath

in the VBIDE immediate window.

[rbunc]

xld, Thanks for the quick reply; I know that the file is already stored in the XLSTART directory, but it still insists on opening up a full page Excel sheet for itself whenever I run on of the macros stored there. Still banging my head here...

[Bob Phillips]

Okay, open Excel and let the file open. ACtivate Personal.xls, then goto Windows>Hide. Shut Excel down and open again and see if starts up with Personal.xls hidden.

[rbunc]

Hey - Thanks ! - Worked like a charm.
Have a great weekend.