Joel,

IF you could get me started on how to do that I would appreciate it, but, I
also want to know if my assumption is correct or did I just do something
incorrectly in writing the code? Does adding the format function to the code
cause it to become a static date?

Thanks!

"Joel" wrote:

Maybe run the macro using one of the events like Workbook Open or Before Print.

"Kay" wrote:

Hello all,

I was just looking at the post for formatting the date in a header. My
question concerns how to get the date to update without re-running the macro.
If you use the default date as added via the header footer toolbar, it
updates fine, but format(date, mmmm dd, yyyy) does not.