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

PrintPreview problem 3
Print Preview Freezes 1
PrintPreview problem in 2007 1
print command from command button in userform causes double chart 5
simple print loop crashes 3
PrintPreview of multiple sheets under Excel 2007 1
PrintPreview error when run from VBA 1
Print with sevral different print area's 2

Top