Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set print areas for multiple sheets simultaneously?
How do I set identical print areas for multiple sheets in the same workbook
simultaneously? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set print areas for multiple sheets simultaneously?
Can you use a macro?
Option Explicit Sub testme() Dim wks As Worksheet For Each wks In ActiveWindow.SelectedSheets With wks .PageSetup.PrintArea = "A1:X99" End With Next wks End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Twirly wrote: How do I set identical print areas for multiple sheets in the same workbook simultaneously? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set print areas for multiple sheets simultaneously?
Ps. You have to group the worksheets that should have the same print area
before running the macro. Click on the first worksheet tab and ctrl-click on subsequent. And after, rightclick on one of the grouped sheets and select ungroup sheets. Twirly wrote: How do I set identical print areas for multiple sheets in the same workbook simultaneously? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set print areas for multiple sheets simultaneously?
Thanks for that information. I'll give it a try.
"Dave Peterson" wrote: Ps. You have to group the worksheets that should have the same print area before running the macro. Click on the first worksheet tab and ctrl-click on subsequent. And after, rightclick on one of the grouped sheets and select ungroup sheets. Twirly wrote: How do I set identical print areas for multiple sheets in the same workbook simultaneously? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
Multiple Print areas in same sheet? | Excel Discussion (Misc queries) | |||
i made one spreadsheet but when i try to print two sheets print, | Excel Discussion (Misc queries) | |||
Formatting all sheets in a workbook to print the same | Excel Discussion (Misc queries) | |||
How do I print all sheets of an Excel workbook from explorer? | Excel Discussion (Misc queries) |