On Oct 19, 10:24 am, MIke wrote:
Hi
Is there a way to automatically lock a cell after a value is entered?

Thanks for the help,
Mike

You can Copy the cell and then Paste Special / Values, and then
Format the cell to be Locked and then Protect the Worksheet, but
that's hardly automatic.

ed