How do I find a lost macro?

G

Gord Dibben

Jan

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

Try Tools>Macro>Macros.

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 <[email protected]> wrote:
 
Top