| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I change page layout in vba
I am trying to find the code to change the page layout from portrait to
landscape without having to rewrite the entire code again. Nowhere in the coding does it distinctively show the page layout properties. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I change page layout in vba
With Worksheets("Sheet1")
.PageSetup.Orientation = xlLandscape .PrintOut End With Copied directly from VBA help on "landscape" Gord Dibben MS Excel MVP On Mon, 18 May 2009 16:05:00 -0700, swanno wrote: I am trying to find the code to change the page layout from portrait to landscape without having to rewrite the entire code again. Nowhere in the coding does it distinctively show the page layout properties. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
| can I change page layout in an entire existing Excel workbook? | Excel Discussion (Misc queries) | |||
| can you change the page layout of all sheets in a workbook | Excel Worksheet Functions | |||
| Are the "page setup" layout settings overwritten by page preview adjustments ? | Excel Discussion (Misc queries) | |||
| Can't change page layout to print one sided for the wholeworkbook | Excel Discussion (Misc queries) | |||
Linear Mode
