LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Customized Toolbar Macro Buttons MSThinksItKnowsBetter Setting up and Configuration of Excel 8 June 1st 08 09:28 AM
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
Customized Macro Button Check [email protected] Excel Discussion (Misc queries) 1 August 11th 07 12:23 AM
Excel 2003 Customized Menu Bar Fernando Gomez Excel Discussion (Misc queries) 2 December 16th 04 10:28 PM
Argument with onAction in a menu. Zeth Larsson Excel Programming 8 December 25th 03 03:21 PM


All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"