| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print from PrintPreview macro method
When I used Office 2003, I can write a PrintPreview Macro and run this macro,
and print each page after run the PrintPreview macro. But now after I changed to office 2007, it seems I can't print from the PrintPreview macro anymore. Anyone knows how to solve this problem. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print from PrintPreview macro method
Hi Stella
As far as I know this is fixed in SP1 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Stella" wrote in message ... When I used Office 2003, I can write a PrintPreview Macro and run this macro, and print each page after run the PrintPreview macro. But now after I changed to office 2007, it seems I can't print from the PrintPreview macro anymore. Anyone knows how to solve this problem. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print from PrintPreview macro method
Not fixed
But you can use this Be sure that ScreenUpdating = True when you call ActiveSheet.PrintOut preview:=True This is not working for example Application.ScreenUpdating = False ActiveSheet.PrintOut preview:=True Application.ScreenUpdating = True -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Stella As far as I know this is fixed in SP1 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Stella" wrote in message ... When I used Office 2003, I can write a PrintPreview Macro and run this macro, and print each page after run the PrintPreview macro. But now after I changed to office 2007, it seems I can't print from the PrintPreview macro anymore. Anyone knows how to solve this problem. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print dialog : problem when user click printpreview | Excel Programming | |||
| UserForm PrintPreview & Print buttons | Excel Programming | |||
| ActiveX Controls moving upon print/printpreview | Excel Discussion (Misc queries) | |||
| macro to disable the printpreview menu | Excel Programming | |||
| [how to] VBA catching close/print in printpreview | Excel Programming | |||
Linear Mode
