I am using office 2003 professional. Setting up a new pc with xp and am use
to using office 2002 with windows 2000.

I have created and saved my "Personal.xls" in the following directory
C:\Documents and Settings\User\Application Data\Microsoft\Excel\XLSTART

My problem is that each time I open excel, the personal.xls workbook is open
as a workbook to use. This is when the file is not "Hidden". When I hide
the file excel doesn't open the personal.xls workbook so I can use the macros.

I've been playing with this all day.

Please help!!!!

Thank you all in advance

"Kimbo" wrote:
I am using office 2003 professional.
I have created and saved my "Personal.xls" in the following directory
C:\Documents and Settings\User\Application Data\Microsoft\Excel\XLSTART

My problem is that each time I open excel, the personal.xls workbook is open
as a workbook to use. This is when the file is not "Hidden". When I hide
the file excel doesn't open the personal.xls workbook so I can use the macros.

Just some thoughts ..

I'm also using Excel 2003. My PERSONAL.XLS is stored in:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
and it seems to work fine ..

The above might also work for you ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hi Max,

Thanks, but I tried and it doesn't work any differently than before. I'll
have to revert to some more reading.



"Max" wrote:

"Kimbo" wrote:
I am using office 2003 professional.
I have created and saved my "Personal.xls" in the following directory
C:\Documents and Settings\User\Application Data\Microsoft\Excel\XLSTART

My problem is that each time I open excel, the personal.xls workbook is open
as a workbook to use. This is when the file is not "Hidden". When I hide
the file excel doesn't open the personal.xls workbook so I can use the macros.

Just some thoughts ..

I'm also using Excel 2003. My PERSONAL.XLS is stored in:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
and it seems to work fine ..

The above might also work for you ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

"Kimbo" wrote:
Hi Max,
Thanks, but I tried and it doesn't work any differently than before. I'll
have to revert to some more reading.

Sorry to hear that. Perhaps also hang around awhile for better insights from
others to flow in here for you ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Why don't you rename that Personal.xls, then record a macro,
ToolsMacrosRecord New Macro..., and then select Personal.xls from the
Store in dropdown. Just stop the recorder without doing anything, and then
go and search for Personal.xls. Like Max I think it will be somewhere else,
then you can just replace that new one with your old copy.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kimbo" wrote in message
...
Hi Max,

Thanks, but I tried and it doesn't work any differently than before. I'll
have to revert to some more reading.



"Max" wrote:

"Kimbo" wrote:
I am using office 2003 professional.
I have created and saved my "Personal.xls" in the following directory
C:\Documents and Settings\User\Application
Data\Microsoft\Excel\XLSTART

My problem is that each time I open excel, the personal.xls workbook
is open
as a workbook to use. This is when the file is not "Hidden". When I
hide
the file excel doesn't open the personal.xls workbook so I can use the
macros.

Just some thoughts ..

I'm also using Excel 2003. My PERSONAL.XLS is stored in:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
and it seems to work fine ..

The above might also work for you ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Thanks Bob,
Your solution work a treat.

P.S. Max, the personal.xls file is in the following directory and works
great. Thanks
C:\Documents and Settings\User\Application Data\Microsoft\Excel\XLSTART

"Bob Phillips" wrote:

Why don't you rename that Personal.xls, then record a macro,
ToolsMacrosRecord New Macro..., and then select Personal.xls from the
Store in dropdown. Just stop the recorder without doing anything, and then
go and search for Personal.xls. Like Max I think it will be somewhere else,
then you can just replace that new one with your old copy.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Kimbo" wrote in message
...
Hi Max,

Thanks, but I tried and it doesn't work any differently than before. I'll
have to revert to some more reading.



"Max" wrote:

"Kimbo" wrote:
I am using office 2003 professional.
I have created and saved my "Personal.xls" in the following directory
C:\Documents and Settings\User\Application
Data\Microsoft\Excel\XLSTART

My problem is that each time I open excel, the personal.xls workbook
is open
as a workbook to use. This is when the file is not "Hidden". When I
hide
the file excel doesn't open the personal.xls workbook so I can use the
macros.

Just some thoughts ..

I'm also using Excel 2003. My PERSONAL.XLS is stored in:
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
and it seems to work fine ..

The above might also work for you ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Good to hear that Bob's suggestion worked for you, Kimbo !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Kimbo" wrote in message
...
Thanks Bob,
Your solution work a treat.

P.S. Max, the personal.xls file is in the following directory and works
great. Thanks
C:\Documents and Settings\User\Application Data\Microsoft\Excel\XLSTART