View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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