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

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"zharrisonremoveatgmail.com" wrote in message oups.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