help finding saved Macro

S

Stonepost

I have created and saved several macros (called Macro 1, Macro 2 etc.) when i
bring up a new file (on a different day) to use that macro I can't find it.
How do i located an what i call an existing macro.
If i select new macro it goes to macro #7, which kind of tells me that there
are macro 1 thru 6 hiding somewhere?

Thanks,
Ed
 
O

OssieMac

When you record macros after re-opening the workbook, it places the new
macros in a new module. With the VBA editor open, look at the project
explorer on the left side. You will see Modules with a number of modules
under it named Module1, Module2 etc. The other macros will be in those. (You
might have to click on the plus sign at the left of modules to expand it.)

You can copy all of the macros into one of the modules and then right click
on the other modules and Remove them.
 
Top