![]() |
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 |
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