Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot display Add-in Macro list without going to VBA/Project
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot display Add-in Macro list without going to VBA/Project
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot display Add-in Macro list without going to VBA/Project
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot display Add-in Macro list without going to VBA/Project
Garry,
Good point. Should mention that Functions from add-ins will appear in the function list (fx) unless made private. Jim Cone "GS" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot display Add-in Macro list without going to VBA/Project
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display "macro-free workbooks - VB project message" on closing Exc | Excel Discussion (Misc queries) | |||
How can remove a project from VBA project list | Excel Programming | |||
macro is not saved in project but in a project.txt version | Excel Programming | |||
With VBA from Excel: Open Project, extract resource list and copy it to a worksheet, close project. | Excel Programming | |||
Not to display Macro list | Excel Programming |