Show Macro list (tools->macro->macros)

[Hafeez Esmail]

I've written some code in Excel.
When I go to Tools --> Macro --> Macros
Nothing shows up.
I have to type in the name of my public sub inorder to run
my code.

What do I need to do in order for other people to view my
routines by going to tools --> macro --> macros?

Thanks
Hafeez Esmail

 

[John Wilson]

Hafeez,

Where did you put the sub???
It should be in a regular (not worksheet or workbook) module.
It should begin with
Sub MacroName()
not
Private Sub xxxxxxx
Make sure it doesn't say
Option Private Module
at the top of the module.

John

 

[Mike Fogleman]

Also, I believe if there are numbers in the macro name ie C7_D9, the macro
will show in the list but the 'Run' button will be dimmed and will not
trigger the macro.

 

[Gord Dibben]

Hafeez

Another point to add to John's.....if the macros are in an Add-in they won't
show in the dialog box.

Gord Dibben Excel MVP

 

[Hafeez Esmail]

It said Public Sub Main; I changed it to Sub Main and it
works

Thanks for your help guys!

Hafeez Esmail

 

[Tom Ogilvy]

I use numbers in my macro names all the time and I have no trouble running
them.