Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I keep the personal.xls from opening? | Excel Discussion (Misc queries) | |||
opening workbooks on startup | Excel Discussion (Misc queries) | |||
Automatically opening several Excel Files at startup | Excel Discussion (Misc queries) | |||
Stopping the PERSONAL spreadsheet from opening at startup | Excel Discussion (Misc queries) | |||
How do I stop book1.xls opening on startup? | Setting up and Configuration of Excel |