Activecell.Value = Format(Date,"dd mmm yyyy")
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"abxy " wrote in message
...
Hi,
I know that Ctrl+; will enter the today's date into an activecell.
Anyway that I can make that (Ctrl+;) into a macro or something so that
I can make it a button on the toolbar. and um, btw, using the TODAY
function isn't my answer becuase it always updates to reflect the
current date. I'm keeping records, so it's no use if the dates always
change.
Thanks in advance
---
Message posted from http://www.ExcelForum.com/