Share custom macros with others?

[bluffpoint]

I've built some custom macros that I'd like to be able to share with a co-worker to save time. Is there an easy way to send him my macros and possibly buttons I've assigned them to?

I think I can just cut and paste the code into an email and then have him do the same but I'm assuming there has to be a much simpler way of doing this.

Thanks in advance.

[jasoncw]

In the project window, right-click on the specific module, class module, form, etc., and select Export. Then email the file to your buddy and have him import it the same way (right-click on a project and select Import).

This won't work for command buttons, etc., that you have designated to certain workbooks, though. He will have to create his own.

[bluffpoint]

I'm not sure what you mean by project window. Sorry for my lack of understanding.

They are saved in my personal workbook as my custom macros, but I can't figure out how to export.

[MSP77079]

Hi Bluff,

You have a couple of options.

The option I use: I assume the macros are in a Module. If you are looking at the code (which means the "the right" Module has focus in the VBE), then, go to the menu in the VBE and choose File >> Export.

This create a small file, which your friend(s) can use File >> Import to import to their workbook(s).

The other option ... the one that Jason was recommending ... ends up in the same place. But, you start by selecting the Module in the little window that looking like Window explorer (little folders and such), called the Project Explorer Window. If you're not sure it's visible, then from the VB Editor menu select View >> Project Explorer. From that window, you find the Module you want and right-click. One of the selections in the Context menu will Export the module.