|
| 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
October 6th 06, 03:40 PM
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. 
|
| Ads |
|
#2
October 6th 06, 03:43 PM
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
October 6th 06, 03:51 PM
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
October 6th 06, 10:42 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| count text strings in an entire workbook | Dave Breitenbach | Excel Worksheet Functions | 1 | September 26th 06 06:29 PM |
| Date last modified - for entire workbook | AndrewPace | Excel Discussion (Misc queries) | 3 | July 11th 06 08:38 PM |
| printing entire workbook | loralei | Excel Discussion (Misc queries) | 1 | March 9th 06 11:35 PM |
| Excel should let me set the print default to "Entire Workbook". | GSL | Setting up and Configuration of Excel | 1 | February 7th 05 08:03 PM |
Linear Mode
