macro in all existing excel

[navinaaaaaa]

I have many excel files in a folder.

I have written a macro.

I want to paste this macro in each of the excel files, so that i can run the macro from any of the existing excel files.

Kindly suggest how can this be made possible.

Thanks in advance.

 

[lenze]

No need to put the macro in each file. Simply place it in your Personal.xls file. With Excel open, choose Window>Unhide.Personal.xls. Place the code in it and rehide. Save. If you don't have a Personal.xls, choose Toosl>Macros>Record New Macro. For store in, choose Personal.xls. Select Record, Select End Record. Excel will now create a Personal.xls for you. Any macro in this file will then be available for all open workbooks.
HTH
lenze

 

[navinaaaaaa]

Thanks for the reply.

But ,my precise requirement is to have the macro in the excel itself.

 

[Smitty]

It will be in Excel. Using Personal.xls makes code available to any open workbook.

 

[navinaaaaaa]

I am not able to understand how to use this personal.xls.

am using excel 2007

 

[ColinKJ]

navinaaaaaa,

Follow the instructions and crerate the personal.xls., which when created, will load and be available everytime you open XL. Any Macro/Routines you write in it can be run / activated either from Ctrl+key or assigned to a button on a tool bar.

I created one about two months ago and wouldn't be without it now.

ColinKJ

 

[texasalynn]

in excel 2007 click on the office button in the upper left and select Excel Options, click on the Show Developer tab in the ribbon, click ok. Now Developer is a ribbon option, click record macro, click on the drop-down Store macro in and select Personal. This will create the personal.xls workbook.

HTH