![]() |
|
#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. |
|
|
Similar Threads
|
||||
| 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 |
Convert large multipage table to jpeg
|
idiotwind | Word Tables | 3 | 12-01-2015 03:53 AM |
Large number of landscape pages within a portrait doc--do I have to textbox by hand every landscape?
|
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 |