Frozen date stamp

The file you posted works for me. Don't forget to exit the cell or press the RETURN key after you enter the name. This macro is a Worksheet_Change event which means that it is triggered automatically when you change the value of a cell. In your case, the change is restricted to column A. This type of macro must go into the code module for the worksheet (which you did correctly) and not in a standard module.