export macros
Ruben, when you record a macro you get the option of where to store it in
the dialog box. The options will be to either store it in 'This workbook'
referring to the workbook you are currently in, or to store it in your
'personal macro workbook' which is usually invisible to you (Assuming you
have one) but opens each time you launch Excel.
If a macro is stored in a workbook then when that workbook is open the macro
is available to be run from that or any other open workbook. If it is in
your personal.xls then it will be available to you no matter what workbook
you are working with.
The macros are stored in what is called a module in either of those two
files and is easily transferrable. I have a lot of macros that I use
regularly that are not specific to any particular workbook, so I keep them
in my personal.xls. I also keep a copy of that personal.xls on a memory
stick that I carry round with me and can then stick it on any machine I work
on, and as a result I can then immediately access all the macros that I am
used to working with. If the macros are specific to a workbook then they
should stay in that workbook and you can run them no matter what machine you
open the workbook with.
Give us an idea of what the macros do and we can suggest the optimal route
to take.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Ruben Mikkelsen" wrote in message
...
IS it possible to take the macros recorded
and copy them to another mashine ? That way I wont have to
record them over and over again for each mashine.
ruben
|