Insert date then lock cell!

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

[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



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

[mevetts]

Will give it a go, thanks.

[pinmaster]

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

HTH
JG

[mevetts]

Cheers Dave, got it working and it's just the job.

Mark.