I have the below code to print specific pages on the backside, it works, but if someone can help me code it to print "map" in landscape orientation (ONLY 'map" sheet in orientation
Right now its printing on on the backside, and it working fine, but if someone can help me change the orientation to Landscape on "Map".. and Sheets (QUOTE, TTTTT, YYYYY, Customer) in portrait
Please Login or Register to view this content.
Add the orientation line of code as per below:
Please Login or Register to view this content.
Last edited by deadlyduck; 12-10-2023 at 06:47 PM.
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
that worked! thank you again deadlyduck!
so that i learn, what does the 1<2 do? 1 is for portrait and 2 for landscape? because i couldnt see that in the syntax
Last edited by chubbychub; 12-10-2023 at 07:30 PM.
1<2 is my way of forcing a TRUE outcome- the switch statement needs one of the pairs of items to be true in order to know what to do. I could possibly have the word TRUE instead of 1<2.
thank you for the explanation deadlyduck, can you make the code with margins 0 at top, 0 at the bottom, 0 left, and 0 right? but only for sheets "map", while the rest of the sheets stays the same? how would i add those properties to only 'map'?
For example (in the code you can specify page settings for each sheet separately):
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks