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.

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


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 09:40:00 -0700, BabzQue
wrote:

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.

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.




"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 09:40:00 -0700, BabzQue
wrote:

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.

It will insert a static date.


Gord

On Mon, 8 Oct 2007 13:22:04 -0700, BabzQue
wrote:

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.




"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 09:40:00 -0700, BabzQue
wrote:

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.