Insert date then lock cell!

M

mevetts

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

Dave Peterson

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
 
P

pinmaster

Hi, another quick way to insert todays date in the selected cell is to
simply hit the CTRL + ; keys.

HTH
JG
 
Top