In an Excel workbook there is some VB coding with various routines. How can
i assign a routine to a toolbar button (I assume this will have to be a
macro button) which will trigger the routine. There are no macros in this
workbook when you press Alt+F8.

Would appreciate your help.

dg

Aless,

The list will not include macros contained behind the worksheet or macros
that are declared as "Private".
You macros must be in a standard module and be public.

Otherwise -
View Toolbars Customize
select the Commands tab and goto Macros
select one of the two choices and drag it to the tool bar.
right click the new button and click Assign Macro
select a macro from the list and click OK.

steve

"Aless" wrote in message
...
In an Excel workbook there is some VB coding with various routines. How
can
i assign a routine to a toolbar button (I assume this will have to be a
macro button) which will trigger the routine. There are no macros in this
workbook when you press Alt+F8.

Would appreciate your help.

dg