If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 ?!? . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook XP email goes to sent folder -receipient doesn't receive,. | Jobde | General Discussion | 3 | February 9th, 2005 04:29 PM |
Barcode reader | Sensay | General Discussion | 3 | February 1st, 2005 07:04 PM |
Export to RTF very slow when code is present in Access report. | [email protected] | Setting Up & Running Reports | 11 | September 14th, 2004 08:17 PM |
Conversion of excel vba code to access vba | filnigeria | General Discussion | 5 | July 15th, 2004 02:23 AM |
Expression - calculating running total | Kathy | Running & Setting Up Queries | 26 | June 22nd, 2004 10:14 PM |