Sub AddHeader()
Dim str As String
str = VBA.Split(ThisWorkbook.Name, ".")(0)
For Each sh In ThisWorkbook.Worksheets
sh.PageSetup.CenterHeader = str
Next
End Sub
Sub AddHeader()
Dim str As String
str = VBA.Split(ThisWorkbook.Name, ".")(0)
For Each sh In ThisWorkbook.Worksheets
sh.PageSetup.CenterHeader = str
Next
End Sub