A single location for all my Macros

[Takeadoe]

Good morning,

I'm wondering if there is a way to get all of the macros that I have
scattered across a bunch of files in a single locations, like
Personal.xls? Some macros are used very infrequently and if I had
them all in one location, I wouldn't have to spend the day looking for
them.

Related to this, is there a simple way to locate all of the macros you
may have hidden in your various workbooks?

As always, your time is greatly appreicated.

Mike,

Athens, Ohio, USA

 

[Bernard Liengme]

Open each workbook; move to VBA editor and for each macro use File | Export
(have a folder ready to receive them)
Open Personal, go to VBA Editor and use File | Import
Now do back and delete macros from the workbooks
best wishes

 

[Takeadoe]

Open each workbook; move to VBA editor and for each macro use File | Export
(have a folder ready to receive them)
Open Personal, go to VBA Editor and use File | Import
Now do back and delete macros from the workbooks
best wishes
--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme









- Show quoted text -

Thank You Bernard!

 

[Dave Peterson]

Start a new workbook (or open the workbook that will get your macros).

Open the first "sending" workbook
go into the VBE
Drag the modules you want from the sending workbook's project to its new home in
the receiving workbook's modules.
close that sending workbook
and open the next
repeat as required.

I'd rename the modules to something significant to be able to find the
procedures, too:

Mod_DoFinds
Mod_FixTextNumbers
....

I wouldn't want all of them named Module###.