potable macros and Tool bar

[PCOR]

I have a number of macros in a file called PERSONAL.XLS
I also have a number of icons on a tool bar that activates the macros.
This is in my office at home
How can I get the macros AND the tool bar to my working office?
I am using Excwl 2003
Thanks

 

[Gord Dibben]

PCOR

I would be tempted to unhide the Personal.xls and with it active go to
Tools>Customize>Toolbars.

Select the Toolbar and "Attach" to your Personal.xls.

File>Save as>File Type>Excel Add-in(*.xla) and give it a name(MyMacros or
similar).

Do not save changes to Personal.xls when asked.

You can now email the MyMacros.xla or copy to a floppy and take to work.

Store it in Office\Library folder and load it via Tools>Add-ins.

The reason I suggest this add-in route is the macros in an attached toolbar in
an *.XLS file will point to the original path in your home computer whereas
the add-in won't.

Gord Dibben XL2002

 

[PCOR]

I will try it
Thanks

PCOR

I would be tempted to unhide the Personal.xls and with it active go to
Tools>Customize>Toolbars.

Select the Toolbar and "Attach" to your Personal.xls.

File>Save as>File Type>Excel Add-in(*.xla) and give it a name(MyMacros or
similar).

Do not save changes to Personal.xls when asked.

You can now email the MyMacros.xla or copy to a floppy and take to work.

Store it in Office\Library folder and load it via Tools>Add-ins.

The reason I suggest this add-in route is the macros in an attached toolbar in
an *.XLS file will point to the original path in your home computer whereas
the add-in won't.

Gord Dibben XL2002