If I want to have the same Word 97 macros (and custom menus and toolbars) on
my home machine as on my office machine, I bring home the Normal.dot file.
Is there an equivalent way of doing this in Excel 97?
Bernard Liengme - 22 Nov 2007 14:59 GMT
Open the files that contain the macros; Open Visual Basic (ALT+F11); click
on each Module in the VBAProject window; Use File| Export to send the macro
to thumb drive (or to hard drive and later to CD)
At home use File | Import to load the BAS files

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> If I want to have the same Word 97 macros (and custom menus and toolbars)
> on
> my home machine as on my office machine, I bring home the Normal.dot file.
>
> Is there an equivalent way of doing this in Excel 97?
Peter T - 22 Nov 2007 15:24 GMT
Your macros may be stored in Personal.xls. If you don't have this already in
your home machine create a new one by recording a dummy macro to your
Personal (can delete it later).
Load a renamed copy of your work personal.xls, in the VBE, F11, drag all
modules from the renamed Personal to your new Personal.
Similarly search your work system for your toolbar *.xlb folder, which in
Excel97 will be named username8.xlb, take a renamed copy home. From memory
(might be wrong about exact way to do this) open the renamed xlb or drag it
into Excel from file. It should merge the settings.
Close & reopen Excel, save your Personal when prompted.
Regards,
Peter T
> If I want to have the same Word 97 macros (and custom menus and toolbars) on
> my home machine as on my office machine, I bring home the Normal.dot file.
>
> Is there an equivalent way of doing this in Excel 97?
John Ciccone - 22 Nov 2007 15:37 GMT