****al,

There is a BefdorPrint event availoable which you could add your code to. Go
to the ThisWorkbook code module, select ThisWorkbook from the left dropdown,
and you will find the event in the right dropdown.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"****al shah" wrote in message
...
.Hi to all

When i give print command from file menu than only macro has to run. is
this
possible.

tnk in advance

****al