VBA function for XL add-ins

S

shnim1

HI

I was wondering if it is possible to code a comand button (on
userforms) so that an application add-in that is installed on my excel
would work. For example,

My add-in has a pull down menu (next to the standard excel pull downs
at the top). When pressed, the first option on the menu is labelled
'calculate'. Now, the VBA code would need to activate this calculate
option.

The add-in manufacturers say that it can be interfaced with VBA, but do
not hint at the code.

Has anyone had this problem?

Thanks in advance
 
C

Chip Pearson

You can try a variation on the following code:

Application.CommandBars.ActiveMenuBar.Controls("Tools").Controls("Calculate").Execute



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Top