Exxporting Macros

N

nosaj_enryb

All,

Is there any way or exporting Macros or the 'Personal Macro Workbook'
in Excel so you can use Macros you have designed on other machines on a
network?

Any help would be great.

Thanks in advance

Jason B
 
N

nosaj_enryb

Thanks Nick,

Trouble is I already have one set up which took me quite a long time t
do. Is there any way I can 'share' this with other users without havin
to redo it as an add-in?
 
N

Nick Hodge

You can export individual modules from the VBE under the file menu or you
could simply transfer your personal.xls to their machine after first
checking they don't have one. In my experience 60% of installations have
never recorded a macro and therefore do not have one. if there is I
wouldn't advocate this route in case you destroy existing functionality


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]


"nosaj_enryb" <[email protected]>
wrote in message
news:[email protected]...
 
Top