Change location of PERSONAL.XLS?

  • Thread starter Thread starter elgo
  • Start date Start date
E

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...)
 
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.
 
Thanks for a great work around!
regards, elgo



Gary''s Student said:
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.
Click to expand...
 
Back
Top