Oliver Gilbert explained on 8/23/2011 :
In Excel 2007, I have made an Add-In (.xlam) which contains several
Subroutines.
This Add-in is in my Add-In folder, hence loads fine when Excel
launches.
However, I cannot display the Add-Ins macros, e.g. with View | Macros,
unless I:

a) go to Developer | View Code
b) expand AND DISPLAY the Modules under the Project Explorer window
for this Add-In
c) then, finally, find the Macro list in Tools | Macros or Run | Run
Macro

Is there any way to make the Add-In Macro (Sub) list visible from the
regular Excel View menu?

XLA[M] macros do not show in the macros dialog. This has always been
the case. If your file is XLS[M], the macros will show in the macros
dialog.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc