Can't see my macro.

  • Thread starter Thread starter mika.
  • Start date Start date
M

mika.

I used the following procedure to create a macro:
1. Open the workbook which contains the data.
2. Press ALT+F11 to activate the Visual Basic Editor.
3. Click Module on the Insert menu to insert a
module. Type the macro above in the module's code window.
4. Click Close and Return to Microsoft Excel on the
File menu.

However, when I try to do the following:
5. Point to Macros on the Tools menu and click Macro.
Select the macro, and click Run.
....I can't, because my macro is not listed! Any
suggestions as to why?

Thanks for the help.
 
could be that you saved the macro in the personal macros module , and
your trying to find it in macros "on this sheet only
check the "macros in " combo box at the bottom of the "run macro "
screen
good luck
Moshe
 
Back
Top