Print is paused by msgbox!

  • Thread starter Thread starter æµæµªçš„åŒé±¼
  • Start date 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
 
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...
 
Back
Top