Dinesh,
These could well be declared as Private procedures, or may even be
Functions. Private are only applicable to the module they are in, so they
don't show, and Functions return a result, so they don't show either.
Does this cover them?
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"Aless" wrote in message
...
Hi Bob
It does not look as if the procedure has any arguments. This is the code:
Private Sub SaveAndPrintInvoice()
ActiveWorkbook.ActiveSheet.PrintOut
End Sub
There are other procedures within the module most of which are without
arguments as well, but none of them show up under list of macros!
Does this make sense?
Dinesh
"Bob Phillips" wrote in message
...
Dinesh,
Just because it's in ThisWorkbook you should still see it from the macro
list. If you can't that probably means that it has arguments. In this
case,
you could create another procedure, in a normal module, to call it with
the
argument value, e.g.
ThisWorkbook.PrintAndSave argValue
and then assign this to a toolbar button. If you want it to be dynamic,
then
you will need to get the argValue via an input box, or the current
selection, or whatever.
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"Aless" wrote in message
...
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