Sharing Macros in Excel 2007

**burningshield** · 10-06-2012, 01:16 PM

Hi there,

I am very new to Excel 2007 and I am wondering whether there is a way of sharing macros that I have created on my computer with other people? Does anyone know if it would be possible to send someone else a macro as a file and install it on their machine or perhaps run a script so that they can enable it as an add-in? Ideally, I would like to find a way of installing a button on their toolbar automatically with my macro linked to it. Is there any way of doing this?

Best regards,

Daniel

**Sadath31** · 10-07-2012, 04:01 AM

Below code will copy module from one workbook.

HTML Code:

**HaHoBe** · 10-07-2012, 04:28 AM

Hi, Daniel,

due to the security system from Office2007 on I doubt you will be able to activate an addin via another workbook or copy the module to a different workbook like suggested by Sadath31. And in 2007 you won´t be able to create a button except on Add-Ins which to my opinion is not a good place (the last place I would look for it).

To create your own tab on a ribbon you need to do so in XML (outside of Excel most of the time), create the callbacks and then fill them in VBA (you may use the Custom Editor available form MS or Andy Pope´s AddIn or any editor and very good knowledge of XML to do so).

I´d prefer to create an AddIn with all the code wanted and a neat tab for especially these macros and make it available to the persons. I would enclose a detailed description on which actions to take to add it to the Add-Ins-Collection but leave it to these persons to do so if they want the AddIn to be used.

Ciao,
Holger

**burningshield** · 10-07-2012, 03:33 PM

Hi guys,

Thank you so much for your useful feedback and suggestions, this is very much appreciated. Holger, I didn't realise that Excel 2007 had security limitations like that, it is good to know. I like the idea that you had about creating an AddIn using the desired code and making it available to others. I have made a simple macro and would like to learn how to create an AddIn as this is something that I have never done before. Do you have any advice as to the steps of converting a saved macro into an AddIn and making this available to others?

Many thanks,

Daniel

**HaHoBe** · 10-07-2012, 04:01 PM

Hi, Daniel,

although the description was made for Excel up to 2003 I think Creating An XLA Add-In For Excel gives you the basic impression on how to write the Addin (okay, the newer versions store as a different file format).

To find out about programming of the ribbon I´d recommend the use of Andy Pope´s RibbonX Visual Designer 2010 which makes it a lot easier then to use the Custom Editor or Notepad to program your own tab for the ribbon.

HTH,
Holger