Static Date in Header/Footer

[Guest]

Hi Everyone, I know it's possible to add a date to a header or a footer by
using &[Date], however when the next user opens the file, it puts in
today's date (the date that the file was opened). I would like to know if
it's possible to use a command to add in a static date in the header/footer
instead of manually typing it in. I have a macro to format the spreadsheet
the way I want it, and this is my only problem right now.

Thanks in advance for any help.

 

[Gord Dibben]

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "mmmm dd yyyy")
End With
End Sub


Gord Dibben MS Excel MVP

 

[Guest]

Thanks Gord but will this make the date static? My problem now is if I save
this file and another user opens it on a different date, the date in the
header becomes the current day that the user opened the file. I want the
header to always have the date I created it.

Any help would be appreciated.

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "mmmm dd yyyy")
End With
End Sub


Gord Dibben MS Excel MVP

Hi Everyone, I know it's possible to add a date to a header or a footer by
using &[Date], however when the next user opens the file, it puts in
today's date (the date that the file was opened). I would like to know if
it's possible to use a command to add in a static date in the header/footer
instead of manually typing it in. I have a macro to format the spreadsheet
the way I want it, and this is my only problem right now.

Thanks in advance for any help.

 

[Gord Dibben]

It will insert a static date.


Gord

Thanks Gord but will this make the date static? My problem now is if I save
this file and another user opens it on a different date, the date in the
header becomes the current day that the user opened the file. I want the
header to always have the date I created it.

Any help would be appreciated.

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = Format(Date, "mmmm dd yyyy")
End With
End Sub


Gord Dibben MS Excel MVP

Hi Everyone, I know it's possible to add a date to a header or a footer by
using &[Date], however when the next user opens the file, it puts in
today's date (the date that the file was opened). I would like to know if
it's possible to use a command to add in a static date in the header/footer
instead of manually typing it in. I have a macro to format the spreadsheet
the way I want it, and this is my only problem right now.

Thanks in advance for any help.