Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions | |||
Second option button disappears when I make another column | Excel Worksheet Functions | |||
Adding Button to Tool Bar | Excel Discussion (Misc queries) | |||
How to edit the size and make it bold of the Option Button text? | Excel Discussion (Misc queries) | |||
Can I make a custom button in Excel for the Group feature? | Excel Worksheet Functions |