Thread: How do I find a lost macro?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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:


Reply With QuoteReply With Quote