Personal.xls not opening at startup

[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??

 

[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

 

[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

 

[kayabob]

No, unfortunately it is not a disabled item. Any other suggestion?

 

[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.