Good Morning! Hope everyone is well.

I have a an excel file that will have over 200 worksheets for each individual employee. The file is set up to hide certain rows and columns for their monthly updates. When we hit the end of the year we un-hide the rows and columns. For the monthly update, I have to set all these 200 + sheets to be PDFed in landscape print view. When we hit the end of the year I need to have all of these files PDFed in Portrait mode. Instead of me selecting every individual sheet and changing print mode. Is there a way to have VBA do that?

I do not need a solution to PDF the files just to toggle between the portrait or landscape depending on the Monthly/Annual information.

I hope that makes sense.

Thank you kindly.