Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Landscape entire workbook
Is there a way to set an entire workbook to print in landscape without having
to select/set each sheet individually? This would be after the workbook has been created. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Landscape entire workbook
right click on the sheet tab, file page setup, landscape
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Carol" escreveu: Is there a way to set an entire workbook to print in landscape without having to select/set each sheet individually? This would be after the workbook has been created. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Landscape entire workbook
If you want to landscape all worksheets, the following macro will do that for
you: Sub LandscapeAll() Dim wb As Workbook Dim ws As Worksheet Set wb = ActiveWorkbook For Each ws In wb.Worksheets ws.PageSetup.Orientation = xlLandscape Next ws Set wb = Nothing Set ws = Nothing End Sub -- Kevin Backmann "Carol" wrote: Is there a way to set an entire workbook to print in landscape without having to select/set each sheet individually? This would be after the workbook has been created. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Landscape entire workbook
Carol
Right-click on a sheet tab and "select all sheets" Set the active sheet for Landscape and all sheets will be done. DO NOT FORGET to right-click and "ungroup" after. Gord Dibben MS Excel MVP On Fri, 6 Oct 2006 07:40:02 -0700, Carol wrote: Is there a way to set an entire workbook to print in landscape without having to select/set each sheet individually? This would be after the workbook has been created. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count text strings in an entire workbook | Excel Worksheet Functions | |||
Date last modified - for entire workbook | Excel Discussion (Misc queries) | |||
printing entire workbook | Excel Discussion (Misc queries) | |||
Excel should let me set the print default to "Entire Workbook". | Setting up and Configuration of Excel |