Probably not possible....but I have a spreadsheet I send to multiple clients
where the rows are grouped on levels 1-5 (5 being the most specific of the
data, therefore most rows). I have set up buttons (macro assigned) which
they can use to print just their columns of data.

The titles to the left of the data are repeating, so each individual macro
is simply selecting the appropriate columns, setting print area, and printing.

I find that levels 1, 2 & 3 of data look best when printed in Landscape.
Levels 4 & 5 look best when printed in Portrait. Is there something that I
can add to a Macro in order for it to print Portrait/Landscape based on the
level of grouped rows selected?

Thanks!