Print is paused by msgbox!

  • Thread starter æµæµªçš„åŒé±¼
  • Start date
Æ

æµæµªçš„åŒé±¼

I use vba code as following to print the worksheet. But the print will go
after the Messege Box disappears. Why? Is there any method to avoid being
paused by Msgbox?
Thanks in advance!
Sub PrintWS()
ActiveDocument.PrintOut
MsgBox "Printint is over!"
End Sub
 
Æ

æµæµªçš„åŒé±¼

I have tried it,but it is of no use.

Joel said:
tyr adding a do event

ActiveDocument.PrintOut
DoEvents
MsgBox "Printint is over!"
Click to expand...
 
K

KC

Excel 2003

I do not have problem, except printout is slower than msgbox appearing.
Are you printing Word application please?

Sub m()
ActiveSheet.PrintOut
MsgBox "printed"
End Sub
 
Æ

æµæµªçš„åŒé±¼

Yes. I am printing Word application.

KC said:
Excel 2003

I do not have problem, except printout is slower than msgbox appearing.
Are you printing Word application please?

Sub m()
ActiveSheet.PrintOut
MsgBox "printed"
End Sub
Click to expand...
 
Top