Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Wolf
 
Posts: n/a
Default 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
  #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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spin button in a work sheet - how do I make it work? [email protected] Excel Worksheet Functions 1 April 7th 05 08:43 PM
Second option button disappears when I make another column Monique Excel Worksheet Functions 0 March 9th 05 09:57 PM
Adding Button to Tool Bar Jenn Excel Discussion (Misc queries) 6 February 23rd 05 09:33 PM
How to edit the size and make it bold of the Option Button text? Cammie Excel Discussion (Misc queries) 1 February 23rd 05 01:57 AM
Can I make a custom button in Excel for the Group feature? Lisa Excel Worksheet Functions 1 December 20th 04 09:34 PM


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"