Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help finding saved Macro
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
help finding saved Macro
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. -- Regards, OssieMac "Stonepost" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding a document I mis-saved | Excel Discussion (Misc queries) | |||
How to remove macro saved on excel folder | Excel Discussion (Misc queries) | |||
Macro to Saved Selected Excel data to .CSV format | Excel Discussion (Misc queries) | |||
Finding and deleting macro in a workbook | Excel Discussion (Misc queries) | |||
saved worksheet opens in new with macro error report | Excel Worksheet Functions |