| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print is paused by msgbox!
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print is paused by msgbox!
tyr adding a do event ActiveDocument.PrintOut DoEvents MsgBox "Printint is over!" "流浪的双鱼" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print is paused by msgbox!
I have tried it,but it is of no use. "Joel" wrote: tyr adding a do event ActiveDocument.PrintOut DoEvents MsgBox "Printint is over!" "流浪的双鱼" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print is paused by msgbox!
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 "流浪的双鱼" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print is paused by msgbox!
Yes. I am printing Word application. "KC" wrote: 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 "流浪的双鱼" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a macro be paused to allow input, then continue? | Excel Worksheet Functions | |||
| how can a macro be paused for input and then resume executio | Excel Programming | |||
| Edit Cells while Macro is Paused at Message Box | Excel Programming | |||
| Print and Copy option - MsgBox() | Excel Programming | |||
| Print button on a msgbox | Excel Programming | |||
Linear Mode
