![]() |
|
#1
|
||||
|
||||
![]() As I said in post #4, the code would work for Word if it didn't paste anything to an Excel workbook, but that's precisely what your code does. In fact, most of it is concerned with the worksheet formatting. As I also suggested you might need to do in post #2, the code basically does a screen capture of the userform and pastes it. For a single multi-page userform, that would take much less time to do manually than it would take for anyone to write the code. Is there a reason for not doing that? FWIW, your code would only process the page of a userform it's attached to.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
I appreciate that your reply reinforces what I already know - that this code will work for excel but not Word. I have no idea how to change it for a Word user form. I also realize the code is for a single page user form; however, as the initial question indicated, I have a multipage (5) user form, and had initial code to print all pages - but in portrait. I have NO IDEA how to modify the code to make it work with a Word document rather than an Excel document. I also indicated in my prior posts that this is being done for users of the user form and will be done more than once; therefore, it needs to be a command button in the form - it is not a one-time screen shot affair - and since I would need five screen shots anyway, I still cannot get there without modifying the code I have (or getting someone willing to help with this rather than just keep pointing out what I don't have).
|
![]() |
|
![]() |
||||
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 |