Show Macro list (tools-macro-macros)
 

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

Show Macro list (tools-macro-macros)
 

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

"Hafeez Esmail" wrote in message
...
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

Show Macro list (tools-macro-macros)
 

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 Esmail" wrote in message
...
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

Show Macro list (tools-macro-macros)
 

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


On Wed, 31 Dec 2003 14:17:49 -0500, "John Wilson"
wrote:

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

"Hafeez Esmail" wrote in message
...
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

Show Macro list (tools-macro-macros)
 

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

Thanks for your help guys!

Hafeez Esmail
-----Original Message-----
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


On Wed, 31 Dec 2003 14:17:49 -0500, "John Wilson"

wrote:

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

"Hafeez Esmail" wrote in message
...
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


.

Show Macro list (tools-macro-macros)
 

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

--
Regards,
Tom Ogilvy

Mike Fogleman wrote in message
...
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 Esmail" wrote in message
...
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