Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get my personal macro worksheet to open whenever I open .
I have Excel 2000 (9.0.7616 SP-3) on a laptop that has Windows XP and
whenever I try to run a macro (saved on my personal.xls worksheet) it shows that my worksheet will not open as a hidden file when I open Excel. I have used another version of Excel on a PC running Windows 2000 and Excel 2000 (9.0.4402 SR-2) and whenever I open Excel my Personal.xls file is opened in the background. Is there a way that I can fix my Laptop to do the same? Any help would be much appreciated |
#2
|
|||
|
|||
Hi
try: - put personal.xls in your XLStart folder - after openening Excel activate this file and use 'Windowsd - Hide' to hide it - close Excel and start it again -- Regards Frank Kabel Frankfurt, Germany "Claudia_R" schrieb im Newsbeitrag ... I have Excel 2000 (9.0.7616 SP-3) on a laptop that has Windows XP and whenever I try to run a macro (saved on my personal.xls worksheet) it shows that my worksheet will not open as a hidden file when I open Excel. I have used another version of Excel on a PC running Windows 2000 and Excel 2000 (9.0.4402 SR-2) and whenever I open Excel my Personal.xls file is opened in the background. Is there a way that I can fix my Laptop to do the same? Any help would be much appreciated |
#3
|
|||
|
|||
Thank you Frank but I actually did do that already and it still will not open
as a hidden file when I start Excel. Do you know of a setting that I have to activate to get it to work? By the way, I also have two other accounts, Default User, All Users and Administrator. Should I copy it into the XLSTART folder on all these accounts? Please let me know. Thanks!!!!! "Frank Kabel" wrote: Hi try: - put personal.xls in your XLStart folder - after openening Excel activate this file and use 'Windowsd - Hide' to hide it - close Excel and start it again -- Regards Frank Kabel Frankfurt, Germany "Claudia_R" schrieb im Newsbeitrag ... I have Excel 2000 (9.0.7616 SP-3) on a laptop that has Windows XP and whenever I try to run a macro (saved on my personal.xls worksheet) it shows that my worksheet will not open as a hidden file when I open Excel. I have used another version of Excel on a PC running Windows 2000 and Excel 2000 (9.0.4402 SR-2) and whenever I open Excel my Personal.xls file is opened in the background. Is there a way that I can fix my Laptop to do the same? Any help would be much appreciated |
#4
|
|||
|
|||
I'd delete all of the except for one.
And I'd find the location of the file to keep by: Start excel hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: ?application.startuppath For me (win98 and xl2002), I get this: C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART Claudia_R wrote: Thank you Frank but I actually did do that already and it still will not open as a hidden file when I start Excel. Do you know of a setting that I have to activate to get it to work? By the way, I also have two other accounts, Default User, All Users and Administrator. Should I copy it into the XLSTART folder on all these accounts? Please let me know. Thanks!!!!! "Frank Kabel" wrote: Hi try: - put personal.xls in your XLStart folder - after openening Excel activate this file and use 'Windowsd - Hide' to hide it - close Excel and start it again -- Regards Frank Kabel Frankfurt, Germany "Claudia_R" schrieb im Newsbeitrag ... I have Excel 2000 (9.0.7616 SP-3) on a laptop that has Windows XP and whenever I try to run a macro (saved on my personal.xls worksheet) it shows that my worksheet will not open as a hidden file when I open Excel. I have used another version of Excel on a PC running Windows 2000 and Excel 2000 (9.0.4402 SR-2) and whenever I open Excel my Personal.xls file is opened in the background. Is there a way that I can fix my Laptop to do the same? Any help would be much appreciated -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
select worksheet to run macro | Excel Discussion (Misc queries) | |||
Linking items GREATER THAN O on another worksheet in the same Work | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |