Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formats in Headers/Footers
How can the format of the current date be changed in an Excel Header or Footer when printing a document from Excel?
-- Paul M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formats in Headers/Footers
Hi
You can use the format function Copy this event in the Thisworkbook module Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim sht As Worksheet For Each sht In ActiveWorkbook.Sheets sht.PageSetup.LeftFooter = Format(Now, "dd-mm-yy") Next sht End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Twoo Doggs" wrote in message ... How can the format of the current date be changed in an Excel Header or Footer when printing a document from Excel? -- Paul M |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Formats in Headers/Footers
Use the beforeprint event to redefine the header . format the date as part
of a string that you build that will appear as you want. Then assign it to the appropriate property of PageSetup. -- Regards, Tom Ogilvy "Twoo Doggs" wrote in message ... How can the format of the current date be changed in an Excel Header or Footer when printing a document from Excel? -- Paul M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Headers/footers | Excel Worksheet Functions | |||
Headers/Footers | Excel Worksheet Functions | |||
Headers and Footers | Excel Discussion (Misc queries) | |||
Headers and Footers | Excel Discussion (Misc queries) | |||
headers and footers | Excel Discussion (Misc queries) |