Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining what menu item called a macro
I'm creating an xla that will add a custom menu that will be added to the
main menu bar. My hope is to have several of the menu items actually tied to the same macro which will run (portions of the) code conditionally based on the calling menu item. Is there a property to determine what menu item called a routine? If so, what is it and are there any limitations I should be aware of? Any additional information would be awesome...i.e., obect/collection information, etc. I didn't find much in Excel's help files. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New menu item OnAction can't see macro? | Excel Programming | |||
Using a Custom Function - determining the row that called it | Excel Programming | |||
re-enabling macro under menu item | Excel Programming | |||
Macro to display a menu item - possible? | Excel Programming | |||
Determining whether function called by Excel or VBA | Excel Programming |