PDA

View Full Version : Quickly accessing a submenu item



musicgold
05-16-2011, 09:39 AM
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.

musicgold
05-20-2011, 08:33 PM
cross posted at
http://www.mrexcel.com/forum/showthread.php?p=2724446#post2724446