Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint Event - "PrintOut" does not give Print Dialog
Hello again!
I have a BeforePrint event to unhide, print, then hide rows again. The problem is that I would still like to allow the use to see the print dialog to choose their own particular settings (such as which tray, double-sided printing, copies, etc.) Is this possible? Is there something else beside the PrintOut command that I should have instead? Here's what I have now: .. .. .. With ActiveSheet .Rows("33:41").EntireRow.Hidden = False .PrintOut .Rows("33:41").EntireRow.Hidden = True End With .. .. .. It works just fine, but I would like the user to get the normal Print dialog window. Thanks in advance! Ronny |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint Event - "PrintOut" does not give Print Dialog
application.Dialogs(xlDialogPrint).Show
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ronny Hamida" wrote in message ... Hello again! I have a BeforePrint event to unhide, print, then hide rows again. The problem is that I would still like to allow the use to see the print dialog to choose their own particular settings (such as which tray, double-sided printing, copies, etc.) Is this possible? Is there something else beside the PrintOut command that I should have instead? Here's what I have now: . . . With ActiveSheet .Rows("33:41").EntireRow.Hidden = False .PrintOut .Rows("33:41").EntireRow.Hidden = True End With . . . It works just fine, but I would like the user to get the normal Print dialog window. Thanks in advance! Ronny |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforePrint Event - "PrintOut" does not give Print Dialog
Thank you, Bob!
"Bob Phillips" wrote: application.Dialogs(xlDialogPrint).Show -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Ronny Hamida" wrote in message ... Hello again! I have a BeforePrint event to unhide, print, then hide rows again. The problem is that I would still like to allow the use to see the print dialog to choose their own particular settings (such as which tray, double-sided printing, copies, etc.) Is this possible? Is there something else beside the PrintOut command that I should have instead? Here's what I have now: . . . With ActiveSheet .Rows("33:41").EntireRow.Hidden = False .PrintOut .Rows("33:41").EntireRow.Hidden = True End With . . . It works just fine, but I would like the user to get the normal Print dialog window. Thanks in advance! Ronny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Display "Sorted by..." Message on Printout | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
BeforePrint Caption = "" | Excel Programming | |||
Aborting from a "Before Print" Event | Excel Programming | |||
What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming |