Userform Print Orientation

cgray46

New Member
Joined
Oct 6, 2002
Messages
2
I wish to print a userform containing 'cell referenced labels' in Landscape orientation.
It prints correctly Thru the VB Editor print options but I can't find the landscape setting for Userforms.

ActiveSheet.PageSetup.Orientation = xlLandscape
Doesnt work.

Please Help

Thnx in Advance
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Fryer Tuck

Board Regular
Joined
Mar 20, 2002
Messages
64
After hitting the "Print" button for the form, check the "Settings" on the print form.
F.T.
 

Juan Pablo González

MrExcel MVP
Joined
Feb 8, 2002
Messages
11,959
Unfortunately, you're not given that much choices about the printing of a userform, you're stuck with the default orientation.
 

Forum statistics

Threads
1,148,337
Messages
5,746,170
Members
423,998
Latest member
eakenila

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top