Print Visible rows and specific columns, force Landscape

[DarrylBurge]

I am trying to get a macro to enable colleagues to print a Briefing Sheet. Rows 12 - 206 hide/show depending the code

Please Login or Register  to view this content.

I have used some very simple code

Please Login or Register  to view this content.

and if I set my orientation to Landscape it prints fine, but if someone else opens the document their local settings override the Landscape/Portrait options.

How am I able to print Visible Rows in A1:E206, in Landscape

[ByteMarks]

Maybe

Please Login or Register  to view this content.