Don't use a formula. Just plop the date in directly--something like this in
your buttonclick code:
with activecell
.value = date
.numberformat = "mm/dd/yyyy"
end with
mevetts wrote:
Hi,
Is it possible to have the formula =TODAY(), but when entered into a
cell is then locked, so it doesn't alter the following day.
I want a button that when clicked, enteres this formula into the
selected cell, but once entered I want the cell to then lock so the
date does then not ever alter.
Can this be done?
Thanks,
Mark.
--
mevetts
------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=494762
--
Dave Peterson