ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to make a Button on a tool bar to launch an Add-in (https://www.excelbanter.com/excel-discussion-misc-queries/32144-possible-make-button-tool-bar-launch-add.html)

Wolf

Is it possible to make a Button on a tool bar to launch an Add-in
 
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

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").Exe cute
If Err.Number < 0 Then
Beep
'msgbox "maybe not loaded???
Err.Clear
End If

End Sub


Wolf wrote:

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


--

Dave Peterson


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com