Header Alignment

S

sprint213

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

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
 
S

sprint213

Explain further how this is done.

[email protected] said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
I'm John, My first post. 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Loop through pages and insert header image 0
Skipping the first row in a repeated header 0
Creating Different Headers in Word 0
Header/Footer Starting Section 5
Format column widths from one table to a separate table on same page 1

Top