Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Header Date
I have a monthly spreadsheet in which I have to change the date in the header
each month. I want to do this automatically so I use the &[Date] feature but it gives me a format like: 11-11-07. I would like it to show November 2007. How can I do this? Thanks.............TomCat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Header Date
Put the following macro in the workbook code area:
Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = Format(Date, "mmmm yyyy") End Sub -- Gary''s Student - gsnu200755 "TomCat" wrote: I have a monthly spreadsheet in which I have to change the date in the header each month. I want to do this automatically so I use the &[Date] feature but it gives me a format like: 11-11-07. I would like it to show November 2007. How can I do this? Thanks.............TomCat |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Header Date
Worked great.........thanks!
"Gary''s Student" wrote: Put the following macro in the workbook code area: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = Format(Date, "mmmm yyyy") End Sub -- Gary''s Student - gsnu200755 "TomCat" wrote: I have a monthly spreadsheet in which I have to change the date in the header each month. I want to do this automatically so I use the &[Date] feature but it gives me a format like: 11-11-07. I would like it to show November 2007. How can I do this? Thanks.............TomCat |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Header Date
One little Problem. I need the header to read Pending and Processing -
November 2007. When I use the macro, it only reads November 2007. "Gary''s Student" wrote: Put the following macro in the workbook code area: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = Format(Date, "mmmm yyyy") End Sub -- Gary''s Student - gsnu200755 "TomCat" wrote: I have a monthly spreadsheet in which I have to change the date in the header each month. I want to do this automatically so I use the &[Date] feature but it gives me a format like: 11-11-07. I would like it to show November 2007. How can I do this? Thanks.............TomCat |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Header Date
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = "Pending and Processing - " & Format(Date, "mmmm yyyy") End Sub -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TomCat" wrote in message ... One little Problem. I need the header to read Pending and Processing - November 2007. When I use the macro, it only reads November 2007. "Gary''s Student" wrote: Put the following macro in the workbook code area: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = Format(Date, "mmmm yyyy") End Sub -- Gary''s Student - gsnu200755 "TomCat" wrote: I have a monthly spreadsheet in which I have to change the date in the header each month. I want to do this automatically so I use the &[Date] feature but it gives me a format like: 11-11-07. I would like it to show November 2007. How can I do this? Thanks.............TomCat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format of Header Date | Excel Discussion (Misc queries) | |||
Date format in Header | Excel Discussion (Misc queries) | |||
Date Format in Custom Header | Excel Discussion (Misc queries) | |||
Date format in Header | Excel Discussion (Misc queries) | |||
format the "date" button for a header | Excel Discussion (Misc queries) |