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!"
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top