How can I use vba to create a pdf from an excel worksheet and force it to print in Landscape mode?
The worksheet is configured for Landscape.
I've tried the Excel Publish to pdf app as well as Ken's PdfCreator code.
The print default always comes up as portrait.
This is very frustrating as I create beautiful landscape pdf's but invariably someone will print 50 copies in the default portrait mode for a meeting.
The worksheet is configured for Landscape.
I've tried the Excel Publish to pdf app as well as Ken's PdfCreator code.
The print default always comes up as portrait.
This is very frustrating as I create beautiful landscape pdf's but invariably someone will print 50 copies in the default portrait mode for a meeting.