View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alan alan is offline
external usenet poster
 
Posts: 3
Default Customized Menu Macro with Argument invoked twice

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.