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.