Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Code for Print Layout
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 ?!? |
#2
|
|||
|
|||
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 ?!? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |