Exxporting Macros

[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

[Nick Hodge]

Jason

You are best to set them up as add-ins and load them via Tools>Add-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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"nosaj_enryb" <nosaj_enryb.1ydybm_1131801901.0551@excelforum-nospam.com>
wrote in message
news:nosaj_enryb.1ydybm_1131801901.0551@excelforum-nospam.com...
>
> 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
>

[nosaj_enryb]

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??

[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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"nosaj_enryb" <nosaj_enryb.1ydzxy_1131804001.3568@excelforum-nospam.com>
wrote in message
news:nosaj_enryb.1ydzxy_1131804001.3568@excelforum-nospam.com...
>
> 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
>