View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Cannot display Add-in Macro list without going to VBA/Project

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"
wrote in message
...
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?