Input current date and lock cell in diffent columns

[stewart1]

Good evening,

I know that there are similar posts regarding inserting dates but I cannot find one that would help me specifically.

If I had for example columns "A", "B" and "C" whereupon if I tabbed or mouse clicked onto any of the cells in those columns it would automatically enter the current date and lock it like "Ctrl ;" does.

So, each column and cell would work independantly of each other.

I would have the worksheet password protected but I would imagine that isn't an issue.

Any help or advice appreciated.

Thanks,


Stewart