Macro integration into add-ins

harinsh

Active Member
Joined
Feb 7, 2012
Messages
273
Hi Team,

I have one macro I want to integrate as add-in file because I can't use this code every time into master file because everyday I download file from my database and need to copy my code into that file and then need to run the macro.

Please suggest me how can I make use my macro in different excel files without copy/paste my code...

Thanks,
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Store it in your PERSONAL project, that way it will be available to all your workbooks in your computer...

If you have never made use of it then you need to create it; recorde a macro (anything) and select Store Macro in: Personal...
Now go to VBE and you'll see it there, delete the recorded macro and store there the ones you wish to made available to all your workbooks.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top