Hello,
I have a macro that runs great thanks to you all. It creates many new tabs
within the workbook. The question is I have a tab named "Outside" in the
workbook it Looks and prints great, how would I format all (45) tabs in my
workbook to look and print in the same format?

any code?

Any help,

Lime

Record a macro using excel's recorder with all the steps you would take
to format the page. Then do something like this:

(air code)

Sub Foo()
Dim wks as Worksheet

For Each wks in Application.Workbooks("MyWorkbook").Sheets
With wks
'Paste code from macro here (with mods to refer to wks, not
activeworksheet)
End With
Next

Set wks = Nothing

End Sub

HTH,
Johnny

hello,
That did not work. I just want to set the same print formatt for all sheets.

"Johnny" wrote:

Record a macro using excel's recorder with all the steps you would take
to format the page. Then do something like this:

(air code)

Sub Foo()
Dim wks as Worksheet

For Each wks in Application.Workbooks("MyWorkbook").Sheets
With wks
'Paste code from macro here (with mods to refer to wks, not
activeworksheet)
End With
Next

Set wks = Nothing

End Sub

HTH,
Johnny

A quick way to do this without code is to right click on the tab of the
sheet with the correct print format, click Select All Sheets, and then
go to File - Page Setup and click OK. This will copy the print
format (except repeating title lines) to all other pages in the group.
Then right click on any tab in the group and click ungroup.