Hi Sam
Wow that worked in getting onto toolbar.
I would like to have several 'run macroxx' on the toolbar. Each one a
different macro to run. I would need an input box to give caption for each
entry on toolbar and a listbox to select the macro from a list of
available macro (from Macro dialog
Yes this can be done
Just a quick scrap here with bare minimum requirements...
Sub AddMacroToToolBar()
Dim lngLoop As Long
Const strMacroNames = "Macro,Delete"
For lngLoop = 1 To 2
With Application.CommandBars("Worksheet Menu
Bar").Controls("&Tools")
On Error
Hi
Xl2000
I want to add some macros to the existing'Tools' toolbar. Have
looked at several on the net. JKP, Contextures, Vbax, etc. They seem to
use mainly a floating toolbar.
I just want to run a macro that says - Add this macro (from a list showing
in current workbook) onto the 'Tool
