Print from PrintPreview macro method

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

Ron de Bruin

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
 

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

Similar Threads

Print Preview Freezes 1
Menu Macro Not Executing - Need Help 1
Need Help with Macro Security 1
Setting column width in a table with a macro is not working 0
Button to print XLS file as PDF 0
Page sort 0
BUG: print command from command button in userform causes double c 0
PrintPreview problem 3

Top