Thread: Check for Print success
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DDonnachie DDonnachie is offline
external usenet poster
  
Posts: 12
Default Check for Print success
Thanks Papou, i'll give it a try

"papou" wrote:

Hello
If Application.Dialogs(xlDialogPrint).Show(arg12:=2) = False _
Then MsgBox "Print was cancelled", vbInformation, "Cancelled"

HTH
Cordially
Pascal

"DDonnachie" a écrit dans le message
de news: ...
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.



Reply With QuoteReply With Quote