How to change location of Personal file

[HN007]

How can I change the location of the Personal file that Excel opens up
with? I do not have access to the folder where it's normally save due
to security restrictions at work.

Thanks.

 

[Gord Dibben]

Why do you want to change the location?

Personal Macro Workbook is stored by default in XLSTART folder which you
should have access to.

If not, talk to your IT people.

A workaround would be select Personal.xls when it is open and File>Save As

MyMacros.xls

Save it to whatever path you have in Tools>Options>General>"At start up,
open all files in"

You can change that path to wherever you want.

I don't know how will prevent Personal.xls from opening if you cannot access
XLSTART to delete the file.


Gord Dibben MS Excel MVP

 

[HN007]

Why do you want to change the location?

Personal Macro Workbook is stored by default in XLSTART folder which you
should have access to.

If not, talk to your IT people.

A workaround would be select Personal.xls when it is open and File>Save As

MyMacros.xls

Save it to whatever path you have in Tools>Options>General>"At start up,
open all files in"

You can change that path to wherever you want.

I don't know how will prevent Personal.xls from opening if you cannot access
XLSTART to delete the file.

Gord Dibben  MS Excel MVP

Thanks this works. However, I am no longer getting the blank "Book1"
on startup.

 

[Gord Dibben]

Trade-off.

Maybe also save a blank Book1.xls in same folder?


Gord

 

[HN007]

Trade-off.

Maybe also save a blank Book1.xls in same folder?

Gord






- Show quoted text -

Great idea. Works beautifully. Thanks.