Hi,
You would best use a separate utility from which to work.

The user can click a button to select whatever and that
button would set the print orientation.

Send me the worksheet so I can see the layout structure.

See my stuff at:
http://www.geocities.com/excelmarksway

- Mark

-----Original Message-----
I have a chart of accounts with departments across the
top.

The accounts down the side are grouped into categorys.

If Level 1 grouping is selected I would like the sheet to
print in Landscape
(fit to 1 page), but if Level 2 grouping (more detailed)
is selected I would
like the sheet to print in Portrait (fit to 1 page).

Can it be done ?!?
.