Header Alignment

[sprint213]

I am looking to see how to align my header flush right and left on a page.
Can anyone help me on this?

 

[Guest]

put this in the workbook before close event.
private sub macMakeBU
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:="H:\Book3.xls", _
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False
end sub

 

[sprint213]

Explain further how this is done.

put this in the workbook before close event.
private sub macMakeBU
ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:="H:\Book3.xls", _
FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False
end sub