![]() |
#1
|
|||
|
|||
![]() I have a Word (not Excel) multipage userform (5 pages). One client wants to have "images" of each of the pages to write on by hand - yes really! I have a command button to print the entire userform with the following sub: Private Sub CommandButton1_Click() For i = 0 To 4 Me.MultiPage1.Value = i Me.PrintForm Next End Sub This of course prints each page in portrait rather than landscape and gets cut off. I could probably change my printer defaults, but for my clients who want to print, I need some code as they won't be able to change their defaults easily. Does anyone have VBA code to add to this sub to get each page in landscape? I am unable to use =wdOrientLandscape, etc., since we aren't talking about word docs; rather the userform itself. Thanks. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Landscape Orientation - Rotate page so top of landscape is printed on left side | swifty2010 | Word | 17 | 06-11-2022 05:50 PM |
![]() |
idiotwind | Word Tables | 3 | 12-01-2015 03:53 AM |
![]() |
mlkmnsgrl | Word | 7 | 01-05-2015 05:19 PM |
Print 2 pages to a sheet in Landscape page orientation | Alexie | Excel | 1 | 09-18-2010 01:29 AM |
Multicolumn Multipage | makaveli89 | Word | 0 | 11-10-2008 11:52 PM |