Quickly accessing a submenu item

[musicgold]

Hi,

I wish to create a shortcut / macro to be able reach a submenu item. I use an Excel plug-in from a third party vendor. I constantly need to use a submenu item in the menu of the plug-in, for which I have to go down two levels of menu.
Is there a way I can have the submenu item as an independent button/icon in my Excel toolbar?
Is it possible to assign the submenu a shortcut using VBA?

Thanks.


Cross posted at
http://www.vbaexpress.com/forum/showthread.php?t=37443

 

[Trevor G]

Can you access the third party VBA code which will give you the access level and perhaps you can then adapt it.

Would it help to mention what the third party menu does for you?

 

[musicgold]

Thanks.

No, I don't have access to the VBA code of the plug-in.

Would it help to mention what the third party menu does for you?

It is just a multi level menu with many functions. It appears to the right of Excel's 'Data' menu. The sub-menu item that I need to use is a refresh button to refresh the data provided by the vendor. Excel's F9 does not refresh data from the vendor.

 

[Trevor G]

What about recording a MACRO to select the menu option and also the refresh then you can assign your own macro to an icon or use keybaord options to run the macro.