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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

what is the key word for merge cell? 1
How do I change the Excel sheet tab bar to display more sheet tabs 2
I want to compare old and new datasheets and highlight changes 3
how can i get duplicate data on excel sread sheet 1
Automating finding pictures 1
Formula help please 5
Range problems with my macro... 2
find newest file in all sub folders 2

Top