PDA

View Full Version : Solved: Hide my "Personal"



rbunc
01-27-2007, 04:34 AM
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. :hi:

Bob Phillips
01-27-2007, 04:45 AM
Store it in the XLSTART directory.

You can find that by typing

?Application.StartupPath

in the VBIDE immediate window.

rbunc
01-27-2007, 05:56 AM
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...:banghead:

Bob Phillips
01-27-2007, 06:16 AM
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
01-27-2007, 06:56 AM
Hey - Thanks ! - Worked like a charm.
Have a great weekend.:clap2: