Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone assist
I have many userforms which at regular intervals will need to be printed, some are to be printed in Portrait others in Landscape. It prints find in Portrait, but how can I change the settings so that it prints in Landscape, I tried the following to no avail by showing the Dialog Printer SetUp and manually changing the setting to Landscape but this still doesn't work. any ideas? Sub Print_UserForm Dim Response as boolean With ufStock_Sheet Response = Application.Dialogs(xlDialogPrinterSetup).Show If reply = False Then Exit Sub .printform End With End sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing in Portrait & Landscape | Excel Discussion (Misc queries) | |||
landscape printing | Excel Programming | |||
Landscape printing? | New Users to Excel | |||
Printing in landscape | Excel Discussion (Misc queries) | |||
landscape printing. | Excel Discussion (Misc queries) |