Format Printing

[patty.baldwin]

I need to format the printing of each of my worksheets in
one file. Is there an easier way to a global format of
entire file other than opening each page and formatting
each page?

 

[BrianB]

Unfortunately they have to be done one at a time. You could, however
record a macro of your actions - presumably you are using File/Pag
Setup - and run it on each of the worksheets.

To apply it to each worksheet in a workbook, you put your code inside
loop like :=

'-------------------------------------
Sub formatting()
Application.ScreenUpdating = False
For Each ws In Worksheets
ws.Activate
'----------------------------------------
'-- put your recorded code here
'----------------------------------------
Next
Application.ScreenUpdating = True
End Sub
'------------------------------------