Greybar at the bottom of the page

[Steven]

I would like to put a grey bar with a height of 6 to print at the bottom of
each page where it works automatically like when you select lines to repeat
at the top...except I want to repeat at the bottom. I looked in the footer
section but I did not see anything there. Is there a way to do this?

Also, can you format dates in the footer like you can in a spreadsheet. I
want for example "WEDNESDAY FEBRUARY 2, 2005".


Thank you,

Steven

 

[Dave Peterson]

xl2002 was the first version to allow you to add a picture to the footer.

And if you use code, you can change the format.

Kind of like:

Option Explicit
Sub testme01()

With Worksheets("sheet1").PageSetup
.LeftHeader = UCase(Format(Date, "dddd mmmm d, yyyy"))
End With

End Sub