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?

The subs will NOT display if...
Option Private Module is specified in the module
The code is not in a regular/standard module
If the subs are private as in... Private Sub NameOfSub
If the subs have arguments as in... Sub NameOfSub(ByRef lngStuff as Long)

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)





"Oliver Gilbert" <(E-Mail Removed)>
wrote in message
news:43bc844c-79a7-4d20-80bf-(E-Mail Removed)...
> 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?

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

Forgot to mention...

Usually, addins create their own toolbars/menus to run their macros.

--
Garry

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

Garry,
Good point.
Should mention that Functions from add-ins will appear in the function list (fx) unless made
private.
Jim Cone


"GS" <(E-Mail Removed)>
wrote in message
news:j30g76$hm$(E-Mail Removed)...
> 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

Jim Cone expressed precisely :
> Garry,
> Good point.
> Should mention that Functions from add-ins will appear in the function list
> (fx) unless made private.
> Jim Cone


Jim,
Also, good point!

--
Garry

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