Print Preview
 

Can I still use Print preview if I have the "application.visible = false"
Code running?

Or how do I get a form to show what is the next best thing?

Thanks in advance

Greg

Print Preview
 

What I mean is what is the next best thing othen than print preview. If not
would making a userform based on a page in the workbook the answer

TIA

Greg

Print Preview
 

Greg

I don't think so. It will work, but your macro will be suspended while an
invisible Print Preview screen is "shown". You should be able to show the
app first though

Application.Visible = True
Sheet1.PrintPreview
Application.Visible = False


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Greg wrote:
Can I still use Print preview if I have the "application.visible =
false" Code running?

Or how do I get a form to show what is the next best thing?

Thanks in advance

Greg