View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,alt.comp.lang.vba,microsoft.public.excel.programming
zharrisonremoveatgmail.com zharrisonremoveatgmail.com is offline
external usenet poster
 
Posts: 1
Default Macros in personal.xls not all showing up in Tools|Macro List

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