| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Page Setup - Fit to one page
I am using following macro to print fit to one page. But it is not happening
and print is actually running on two pages. With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = "" .Orientation = xlLandscape .LeftFooter = "Left Footer text: " .RightFooter = "Right Footer Text: " .FitToPagesWide = 1 .FitToPagesTall = 1 End With Can any one help me understand the reason why I am not able to get print fit to single page and what change do I need to make to my code. -- Yogesh Gupta |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro for Page Setup - Fit to one page
add
..zoom = false to the other conditions within your with. Sam "Yogesh Gupta" wrote: I am using following macro to print fit to one page. But it is not happening and print is actually running on two pages. With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = "" .Orientation = xlLandscape .LeftFooter = "Left Footer text: " .RightFooter = "Right Footer Text: " .FitToPagesWide = 1 .FitToPagesTall = 1 End With Can any one help me understand the reason why I am not able to get print fit to single page and what change do I need to make to my code. -- Yogesh Gupta |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
| FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
| HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
| Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
| Page Setup Macro | Excel Programming | |||
Linear Mode
