~just a question:

is there a reason to use the dialog instead of just printing for them?

thisworkbook.printout

are they all printing to the same printer, or is it their default, is
it a network printer etc?

(I dont know personally how to see if they pressed ok to print, so
easier would be to see if we could remove the dialog)

Duncan


DDonnachie wrote:

Hi

ok using the following code to bring up print dialogue

Application.Dialogs(xlDialogPrint).Show arg12:=2

but I have code which I only want to run if the print has been successful.
Obviously they can cancel out of this dialogue without printing, which I
want to know.