Copy macros from one workbook to another

[pboltonchina]

Hi Everyone,

I have all my macros stored in Personal which opens with Excel and that's fine. However, some of these macros need to be stored within a particular workbook so they are available to anyone opening that workbook. At the moment when I need to do this, I insert a module and manually copy and paste the required macros into the new module. I was just wondering if there was a quicker way to do this, like Importing Modules, or Copy Modules, or something that would make it a bit quicker and easier?

Thanks for looking at my post, any help greatly appreciated

 

[VoG]

In the VBE you can use File > Export to export the module then in the other workbook File > Import.

 

[pboltonchina]

Thanks VoG, that works a treat. Can you do it with multiple modules at once, or is it a one at a time thing?

 

[VoG]

As far as I know you can only do one at a time.

 

[pboltonchina]

Hi Vog,

Thanks for that.

Kind Regards

Paul

 

[VoG]

You are welcome.

Another possibility to consider is creating an Add-in that you can distribute to others - see http://www.fontstuff.com/vba/vbatut03.htm