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


Thanks for the suggestions. I downloaded Walkenbach's table driven menu
system. This works nicely, there are a few limitations:

- I finally identified how to include web links for some menu items. I
had to add another field to the table for the web link and update the
VBA code to set the menu item appropriate attributes.

- I want one menu item to popup the Outlook Express Send mail window
with the "To" and Subject Field initialized. I have not found a way to
start Outlook Express Send from VBA. There are many examples using
Sendmail and Outlook, but I haven't found one for Outlook Express Send.
The Menu Editor allows you to do this so it is possible.

- Cannot specify an argument for the macro. May need more columns for
the arguments.

I still receive "firing twice" when invoking a menu item macro with an
argument. I've tried removing the () as suggested, I receive an error
and cannot enter it. I've noticed my Menu Editor list of user defined
functions (ie macros) is a small subset of the udf's (ie user defined
functions) listed in the Toolbar Insert Function udf. I think the
problem may be related to the missing udf's in the Menu Editor. Any
suggestions on how to update the Menu Editor udf list to be consistent
with the Toolbar Insert Function udf list? They should be the same.

thanks.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!