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
|