Running the same macro to multiple workbooks

[Raman325]

Hi, I have 16 workbooks that a macro needs to be applied to. Is there an easy way to do this without copying the macro into each workbook individually? Thanks in advance.

[Kaak]

Write teh macro in a master WB and from there open the other WB's
and run the macro on the active WB.

[Norman Jones]

Hi Raman,

(1) Put the macro in your Personal.xls workbook. It is then available to any
open workbook.

If you do not have a Personal.xls workbook, record a dummy macro, and select
the 'Personal Macro Workbook' option from the 'Store Macro In' dropdown.
This will create the Personal workbook for you. It will open hidden each
time that you open Excel. The dummy macro can be deleted.

OR,

(2) Store the macro in a new workbook and save the workbook as an Addin.

To do this, select 'Microsoft Excel Addin (*.xla)' {the last option) in
'Save asType' dropdown. Then,

Tools | Add-Ins | Browse | select your file | Ok

---
Regards,
Norman








"Raman325" <[email protected]> wrote in
message news:[email protected]...
>
> Hi, I have 16 workbooks that a macro needs to be applied to. Is there an
> easy way to do this without copying the macro into each workbook
> individually? Thanks in advance.
>
>
> --
> Raman325
> ------------------------------------------------------------------------
> Raman325's Profile:
> http://www.excelforum.com/member.php...o&userid=24748
> View this thread: http://www.excelforum.com/showthread...hreadid=383795
>

[Raman325]

Thanks, I'll give it a try.