Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-12-2016, 09:23 AM
mktate mktate is offline Print Multipage Userform in Landscape Windows 10 Print Multipage Userform in Landscape Office 2010 64bit
Novice
Print Multipage Userform in Landscape
 
Join Date: Dec 2015
Posts: 26
mktate is on a distinguished road
Default Print Multipage Userform in Landscape


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.
Reply With Quote
 



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
Print Multipage Userform in Landscape Convert large multipage table to jpeg idiotwind Word Tables 3 12-01-2015 03:53 AM
Print Multipage Userform in Landscape 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft