Copying a macro

rainman1234

New Member
Joined
Feb 7, 2005
Messages
7
I have a macro that I use in a spreadsheet. Each week I have a different SS to work on and need to import this macro. What is the best and easiest way to do this.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Nimrod

MrExcel MVP
Joined
Apr 29, 2002
Messages
6,259
Suggestion 1:
Transform your macro into an "AddIn" so that it's available to all workbooks all the time. (tecniques to make addin's are been discussed many times here so just do a search to learn how to do)

Suggestion 2:
Just have your source book open each time you want to work on a new SS and run it from the old book.

Suggestion 3:
To copy macro just Open the VBEditor window using Alt + F11 and drag the module with the macro in it from one workbook to the other in the "Project Window".
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
Nimrod,
Can any Macro be turned into an AddIn? If so, I need to search this!!

Thanks Michael
 

Nimrod

MrExcel MVP
Joined
Apr 29, 2002
Messages
6,259
Pretty much any macro can be saved as an XLA and then made into an Add-in .... Search the posts and you will find lots of info on this.
 

rainman1234

New Member
Joined
Feb 7, 2005
Messages
7
Having problem with AddIn

I am having problems saving the VB script to an AddIn. I am new to the excell AddIn process. My vbs has an extension of .bas. Is this the problem?

brian
 

Watch MrExcel Video

Forum statistics

Threads
1,122,576
Messages
5,596,968
Members
414,115
Latest member
SFUser

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
Top