Yes, Joel, I understand that and therefore, why I was trying to do it via
code. Thanks for all of your help. I think what I have done will work fine.
Have a great day!

"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.