Creating PDF On Mac: Multiple Sheet Orientation

masouder

New Member
Joined
Jul 5, 2013
Messages
48
I am attempting to create a PDF including several sheets from a Mac. (I am a PC user, but am doing this for a client who is Macs.) I referenced Ron de Bruin excellent post on the subject (https://www.rondebruin.nl/mac/mac005.htm), but there is one thing that is not working.

The workbook that I am converting to PDF includes three sheets: sheets 1 and 3 are landscape orientation and sheet 2 is portrait orientation. I included the following line of code for all sheets, as suggested by Ron:

Code:
ActiveSheet.PageSetup.Orientation = ActiveSheet.PageSetup.Orientation
However when I create the PDF all sheets - including sheet 2 - are set to landscape orientation.

Any ideas how to overcome this issue?

Thanks in advance for any help.
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,102,367
Messages
5,486,443
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top