Personal.xls not opening at startup

K

kayabob

I have to open personal.xls manually everytime excel starts. The file is
placed in the XLSTART folder, which I believe is correct. Personal.xls is
still open and hidden when I shut Excel down. Then when I restart,
Personal.xls doesnt automatically start up. Any suggestions??
 
R

RichardSchollar

Hi

If you click Help>About Microsoft Excel>Disabled Items do you see
Personal.xls listed there? If so, re-enable it.

Hope this helps!

Richard
 
G

Gord Dibben

There will be more than one XLSTART folder.

Which one Personal.xls uses is up to Excel.

If you created Personal.xls by recording a macro into "personal macro workbook"
then Excel will create Personal.xls and stick it in the correct XLSTART folder.

C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART is
the common path.

Check for it there.

Or try this method to get the path.

hit alt-f11 to get to the vbe
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath


Gord Dibben MS Excel MVP
 
K

kayabob

This is the exact path that the file is in. And I did create my macros by
the method you are describing. all macros work properly once I manually open
the file. My only issue is to just get it to start automatically when Excel
opens.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top