The code is in ThisWorkbook module and one of the procedures is PrintAndSave
which I want to be able to run from the work sheet but I don't know how to.

Thank you for your help.

Dinesh Gudka

"Bob Phillips" wrote in message
...
Not clear what you are saying here. If there are no macros, where is the
VB
code that you refer to?

And why do you want to put it to a toolbar button? I assume that the code
may be event code, and sitting in a sheet code module or the ThisWorkbook
module.

Tell us where it is and what you want to do with it.

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks


"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