Hi guys,

I have a shared workbook that we use for work, which have sheets that are protected but some cells are not locked so that my colleagues can enter data (such as TIME, to be exact.) Currently, we are using CTRL+SHIFT+; to enter the time.

The thing is, what I want to happen is that when the user inputs the time (i.e. pressing CTRL+SHIFT+; , then enter) the cell will display the time, as normal, BUT locking the cell. In effect, the user can't alter the time. Is this possible?

The thing with doing an auto-lock-after-cell-entry is that, what happens when the user mistypes or "mis-presses" the keys? For instance, pressing CTRL+; will display the date. Or accidentally pressing any key then enter will lock it. What I was thinking is a designated KEY for that "macro" to happen.

Here's my idea:
On the cell, when user enters "A", the cell will show the time, and lock it.
If the user inputs any other character, it will not lock it.

This does not only solve the wrong button being typed, but also prevents the user to manually type-in his/her time.

Can you guys help me out on this one? THANK YOU!