Macros in personal.xls not all showing up in Tools|Macro List

[zharrisonremoveatgmail.com]

Hi all-

I have a bunch of macros defined in multiple macros in my personal.xls.
They are all defined with "Sub", none of them are public or private.
However, only some of them show up in the listbox if I goto
Tools|Macro. If i manually type in:

PERSONAL.XLS!<macro name>,

then the Run button un-graysout and excel recognizes it.

How can I get all of my macros to show up in the listbox?

Thanks

zach

 

[David McRitchie]

You will not see macros that have a parameter even though
you can invoke without the parameter.

Usual cause of grayed out menu items is shared workbook,
or protected workbook, worksheet. Though it is not a menu
that you say is grayed out you might check.

The microsoft.public.excel.programming is the correct newsgrouip.