View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Thomas is offline
external usenet poster
 
Posts: 107
Default Programmatically call a menu item from a menu from a Add-in

I have the Hyperion Smart View add-in in my Excel. I tried to add a command
button which basically will call a command item on this Hyperion menu.

When I used the
Application.CommandBars("Hyperion").Controls("Memb er Select...").Execute

in the VBA code, it does not work. The error message is "Runtime error 5:
invalid procedure call or argument".

If I call an Excel standard menu item, it works fine.

Does anyone know how to programmatically call a non-Excel standard menu item
that comes from a third-party add-in?

Thanks a lot in advance!