Try this then.
Set the single active sheet to all of your print settings.
When you are done, right click the sheet tab that has the proper print settings, and click Select All Sheets on the shortcut menu.
Then, click File, Page Setup on the Menu bar. When the page setup dialog box displays, just click OK.
The page setup settings should be on all sheets.
Berg
berg said:Try this then.
Set the single active sheet to all of your print settings.
When you are done, right click the sheet tab that has the proper print settings, and click Select All Sheets on the shortcut menu.
Then, click File, Page Setup on the Menu bar. When the page setup dialog box displays, just click OK.
The page setup settings should be on all sheets.
Berg
How can I do this in EXCEL 2010?
Click the 1st worksheet, then SHIFT Click the last worksheet. All worksheets will then be grouped.
When you set print settings, they will be applied to all of the selected sheets.
Just be sure you don't forget to ungroup the sheets when you are through. Just click any sheet tab to ungroup them.
Berg
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> "Data" Then ' Exclude sheet(s) by name
'Enter code that you want to apply to all sheets here (from recorded macro)
With ActiveSheet.PageSetup
.BlackAndWhite = False
End With
End If
Next ws