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


.