redirecting personal.xls

B

BorisS

I want to have personal.xls sit in a different location. Possible?

The reason, in case it matters for purpose of a solution, is that I synch
three different computers (work to laptop, laptop to home) with briefcase,
and want to have the personal macro there, so that anything I do in one place
replicates to the others.

Thanks
 
B

Bob Phillips

I don't think that it is. The system determines where XLSTART is located,
and that is where Personal.xls belongs.

--
HTH

Bob Phillips

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

Leo Heuser

BorisS said:
I want to have personal.xls sit in a different location. Possible?

The reason, in case it matters for purpose of a solution, is that I synch
three different computers (work to laptop, laptop to home) with briefcase,
and want to have the personal macro there, so that anything I do in one
place
replicates to the others.

Thanks
Click to expand...

Boris

This seems to work, at least in Excel 2000 (and forward I guess):

1. Move personal.xls to where you want it to be.
2. Create a shortcut to personal.xls
3. Move the shortcut to XLStart
 
B

BorisS

Great idea. It worked. Only issue is that now Personal opens up as a
separate file, as opposed to being hidden, as it was when residing in
XLStart. Any ideas? Thx.
 
L

Leo Heuser

BorisS said:
Great idea. It worked. Only issue is that now Personal opens up as a
separate file, as opposed to being hidden, as it was when residing in
XLStart. Any ideas? Thx.
Click to expand...

Thanks for the feedback.

Dennis' suggestion should do the job.
From a sheet in Personal.xls choose
Window > Hide. When ending the session,
answer "yes" when asked, if you want to save
changes to Personal.xls.

You may encounter a problem, if you have
(in some workbook) a call (e.g. from a button)
to Personal.xls.
You will get an error because it will show
the new *path* to Personal.xls.
Just change it to the sub in Personal.xls.


Leo Heuser
 
Top