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

  • Thread starter Thread starter Hafeez Esmail
  • Start date Start date
H

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
 
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
 
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.
 
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
 
It said Public Sub Main; I changed it to Sub Main and it
works:-)

Thanks for your help guys!

Hafeez Esmail
 
Back
Top