Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plot Area Automatically Expands in Print and Print Preview | Charts and Charting in Excel | |||
First page of Excel sheerepeats in print layout or print preview | Excel Discussion (Misc queries) | |||
Print and Print Preview Graphic Moving Resizing 2007/2003 | Excel Discussion (Misc queries) | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
cell borders that I create dont show on print preview or print | Excel Discussion (Misc queries) |