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

Hi

If you click HelpAbout Microsoft ExcelDisabled Items do you see
Personal.xls listed there? If so, re-enable it.

Hope this helps!

Richard


On 12 Mar, 14:13, kayabob wrote:
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??

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

On Mon, 12 Mar 2007 07:13:21 -0700, kayabob
wrote:

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

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

"RichardSchollar" wrote:

Hi

If you click HelpAbout Microsoft ExcelDisabled Items do you see
Personal.xls listed there? If so, re-enable it.

Hope this helps!

Richard


On 12 Mar, 14:13, kayabob wrote:
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??

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.

"Gord Dibben" wrote:

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

On Mon, 12 Mar 2007 07:13:21 -0700, kayabob
wrote:

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