Excel userform printing

[boona1]

Is there any way of setting up an excel userform to print in landscape format either by coding or through the properties window. Using the printform function automatically prints in portrait.

Thanks in advance

 

[TLady]

Here is how it goes:

open Excel file
Tools/Macros/Record New Macro/OK

Now go
File/Page Setup/Landscape/OK

Now Go
Tools/Macro/Macros/Edit

You will see whole 9 yards of code
So, pick

With ActiveSheet.PageSetup
.Orientation = xlLandscape
End With

Worked ? I hope

TIA

 

[boona1]

Thanks for this.

I use this code for standard excel worksheets but userforms seem to have another set of rules when it comes to printing.

Gareth