Exxporting Macros
 

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


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile: http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484521

Exxporting Macros
 

Jason

You are best to set them up as add-ins and load them via ToolsAdd-ins...
You may need some slight code adaptations but this is the best way

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"nosaj_enryb"
wrote in message
...

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


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile:
http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484521

Exxporting Macros
 

Thanks Nick,

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


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile: http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484521

Exxporting Macros
 

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
HIS


"nosaj_enryb"
wrote in message
...

Thanks Nick,

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


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile:
http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484521