Train them to use CTRL + ; to enter a static date.


Gord Dibben Excel MVP

On Wed, 9 Mar 2005 13:53:02 -0800, abe wrote:

We have a worksheet that we want users to be able to press a button on the
worksheet & which in the next cell near the button, it would stamp the
current time and/or date from the system. Then the cell with the date and/or
time would be unable to be changed once the button is pressed (locked)