Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created customized Menus which invoke macros, web
links and email. The menu buttons work properly except for the menu buttons which contain a macro with an argument. When the menu button is selected, the macro is invoked twice. If I remove the argument, the macro is invoked once. I've tried this with several macros and menu buttons, same behavior on all of them. This only happens when invoked from a menu button. How do I include an argument and prevent the macro from being invoked twice? Also, I'd like to dynamically create/delete my customized menus at startup/shutdown. Other forum threads discuss how to do this, but this technique appears to have many potential pitfalls. Has anybody successfully implemented this for all cases? My MS Excel book recommends distributing an *.xlb file with the menu customizations and request the user creates a shortcut to this file. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Customized Toolbar Macro Buttons | Setting up and Configuration of Excel | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
Customized Macro Button Check | Excel Discussion (Misc queries) | |||
Excel 2003 Customized Menu Bar | Excel Discussion (Misc queries) | |||
Argument with onAction in a menu. | Excel Programming |