Is it possible to make a Button on a tool bar to launch an Add-in

W

Wolf

Is it possible to make a button on a tool bar to launch an add-in? The
add-in is now part of my Tools menu, but I want to be able to activate
Symbolizer from my tool bar, instead of pulling it down from a menu
 
D

Dave Peterson

Is this Chip Pearson's Symbolizer addin?

If yes, is it the .dll (COM addin or the VBA version)?

I loaded the COM Addin version and got a new menu item:
Tools|Symbolizer|Symbolizer

If that's the same location for you, you could use a macro like this (and have
that macro assigned to a shortcut key or a toolbar icon):

Option Explicit
Sub testme()

On Error Resume Next
Application.CommandBars("worksheet menu bar").Controls("tools") _
.Controls("symbolizer").Controls("symbolizer").Execute
If Err.Number <> 0 Then
Beep
'msgbox "maybe not loaded???
Err.Clear
End If

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top