I have a custom footer and used the date button to have it show the date,
but my boss wants it to show in a different date format, specifically:

16-Jan-07

How do I modify the "[Date]" that the button inserted in the footer to have
this revised format?

Thanks!
Dean

You must use VBA for that Dean

See
http://www.rondebruin.nl/print.htm#Saved

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message ...
I have a custom footer and used the date button to have it show the date,
but my boss wants it to show in a different date format, specifically:

16-Jan-07

How do I modify the "[Date]" that the button inserted in the footer to have
this revised format?

Thanks!
Dean

This looks like great stuff to have, Ron. Thanks so much. I have
bookmarked it - is a textbook to follow someday?

I don't see that it specifically addresses what I need at this moment,
however. Perhaps it is implied in one of your many topics. Can you help?

By the way, do you mean that I would have to run a macro every time I wanted
to print any worksheet?

Dean

"Ron de Bruin" wrote in message
...
You must use VBA for that Dean

See
http://www.rondebruin.nl/print.htm#Saved

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I have a custom footer and used the date button to have it show the date,
but my boss wants it to show in a different date format, specifically:

16-Jan-07

How do I modify the "[Date]" that the button inserted in the footer to
have this revised format?

Thanks!
Dean

Hi Dean

This is event code that run automatic if you press the print button
Be sure you copy it in the Thisworkbook module

You see the Format function in the example that display the date as you want it

Use this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ThisWorkbook.Worksheets
wkSht.PageSetup.RightFooter = "&8Date : " & _
Format(Date, "dd-mmm-yyyy")
Next wkSht
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message ...
This looks like great stuff to have, Ron. Thanks so much. I have
bookmarked it - is a textbook to follow someday?

I don't see that it specifically addresses what I need at this moment,
however. Perhaps it is implied in one of your many topics. Can you help?

By the way, do you mean that I would have to run a macro every time I wanted
to print any worksheet?

Dean

"Ron de Bruin" wrote in message
...
You must use VBA for that Dean

See
http://www.rondebruin.nl/print.htm#Saved

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I have a custom footer and used the date button to have it show the date,
but my boss wants it to show in a different date format, specifically:

16-Jan-07

How do I modify the "[Date]" that the button inserted in the footer to
have this revised format?

Thanks!
Dean

works nice - thanks much, Ron!

"Ron de Bruin" wrote in message
...
Hi Dean

This is event code that run automatic if you press the print button
Be sure you copy it in the Thisworkbook module

You see the Format function in the example that display the date as you
want it

Use this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In ThisWorkbook.Worksheets
wkSht.PageSetup.RightFooter = "&8Date : " & _
Format(Date, "dd-mmm-yyyy")
Next wkSht
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
This looks like great stuff to have, Ron. Thanks so much. I have
bookmarked it - is a textbook to follow someday?

I don't see that it specifically addresses what I need at this moment,
however. Perhaps it is implied in one of your many topics. Can you help?

By the way, do you mean that I would have to run a macro every time I
wanted to print any worksheet?

Dean

"Ron de Bruin" wrote in message
...
You must use VBA for that Dean

See
http://www.rondebruin.nl/print.htm#Saved

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dean" wrote in message
...
I have a custom footer and used the date button to have it show the
date, but my boss wants it to show in a different date format,
specifically:

16-Jan-07

How do I modify the "[Date]" that the button inserted in the footer to
have this revised format?

Thanks!
Dean