How do I find a lost macro?
 

How do I find a lost macro?
 

Where was it when you last saw it?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Jan"
wrote in message
...

How do I find a lost macro?
 

Jan

Macros can live in workbooks, add-ins or perhaps in your Personal.xls

Try ToolsMacroMacros.

Does the macro name appear in the list?

If it doesn't appear in the list it could be a Private Sub or lives in an
add-in or is event code in a worksheet or Thisworkbook module.

In that case, hit ALT + F11 to open the Visual Basic Editor.

You will have to browse through the Projects and find the module with the macro.


Gord Dibben MS Excel MVP


On Mon, 23 Jul 2007 06:34:16 -0700, Jan wrote: