Distribute a macro to multiple users

**simjambra** · 05-28-2010, 09:46 AM

Hi there

Quick question. If you have edited a macro, and need to roll the changes out to about 150 pcs, what would be the best way of doing so?

Currently everyone has a set of Macros in NORMAL but they need to be changed.

Also, can I be cheeky and ask Can a set of VBA features be implemented as an 'Add-In' instead?

Thank you very much

**shg** · 05-28-2010, 11:07 AM

Can a set of VBA features be implemented as an 'Add-In' instead?

http://www.fontstuff.com/vba/vbatut03.htm

**simjambra** · 05-28-2010, 11:10 AM

That looks very interesting, thank you.

**royUK** · 05-28-2010, 12:41 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**simjambra** · 06-28-2010, 07:03 AM

Hi Roy,

Sorry I thought I would leave it as Unsolved as I'm still struggling with the first part of my query.

Many thanks

Simon

**royUK** · 06-28-2010, 07:12 AM

If you create an Excel addin then make changes in the mastercopy by changing the ISADDIN Property to false. When finished change it back to True. Then distribute the new version with instructions to overwrite the previous version.

You could also have an addin stored on the network & all PCs could access the one addin, see network addin

**simjambra** · 06-28-2010, 07:18 AM

Excellent, looks good.

I'll get stuck into these.

Thanks again.

*edit*
I can't edit the thread title - it may have been too long ago, apologies for this but I have been off work for a few weeks, since the Mrs gave birth

-
If a moderator is able to mark as solved, I would be very grateful, thanks