Change location of PERSONAL.XLS?

[elgo]

Is it possible change the default location of where PERSONAL.XLS is stored?
I want to put it on a network drive to have my macros available on all
machines(The C disc is not syncronized or backed up...)

 

[Gary''s Student]

Another way to achieve your goal is to put your commonly used macros in a
special workbook, say elgo.xls, and put this workbook on the server in a
special subdirectory.

and then:

Tools > Options > General > at startup open all files in

Whenever you run Excel, you macros will be available.

 

[elgo]

Thanks for a great work around!
regards, elgo

Another way to achieve your goal is to put your commonly used macros in a
special workbook, say elgo.xls, and put this workbook on the server in a
special subdirectory.

and then:

Tools > Options > General > at startup open all files in

Whenever you run Excel, you macros will be available.