Hi

Sub MySub
......
continue=MsgBox("Are you sure you want to print it?",vbYesNo)
If Not continue Then Exit Sub
....
End Sub


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"vandana" <u44172@uwe wrote in message news:858fb7a784b2d@uwe...
Hi...

I have created a macro and one of the command button with marco is to
directly to print. now i need to insert a pop up (logical function) saying
"u
sure you want to print" and this should have 2 answers "yes" and "no" if
"yes" continue with printing and if "no" cancel printing.

can any one help me with this please.