Print from PrintPreview macro method

  • Thread starter Thread starter Stella
  • Start date Start date
S

Stella

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!
 
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
 
Back
Top