VBA questions about where to put macros available to all workbook

[cazdealer]

Hi,
I have different macros in different workbooks.
Now, it's complicated for me if I want to use a macro I created in another workbook. I have to open VBA copy it to the new workbook.
I'm sure there is a way to make the macros available to any workbook.

so 2 questions:

1: Where do I put those macros (right now, there are in Module,1,2,3,4 of different workbooks).

2: Some macro use this code line at one point
thisworkbook.active
because it switches from one workbook to another...
will this still work if the macro is not written anymore in the module of that particular workbook?


thanks

 

[Dryver14]

are they for public consumption or could they just not live in your personal workbook

 

[cazdealer]

I don't really understand your questions...

I want to use them with any workbook I open with my own Excel. I don't want to have to always copy the VBA from the workbook it's in right now.

I would like to put them somewhere in my own Excel or VBA to with allow me to use them with only my computer.

 

[Dryver14]

Have you not created a personal macro file?

You need to do that and then when you place the macros in there they will be available to you whatever folder or workbook you are in.

look here

http://excelhints.com/2010/11/29/how-to-use-your-personal-macro-workbook/

 

[cazdealer]

thanks