Hi,

You can't lock the cell without turning on sheet protection. It's like an electric fence around a field. Unless the electricity is turned on the fence doesn't prevent animals straying.

What are you trying to achieve?

You may find that adding code syntax Sheet.Protect and Sheet.Unprotect in your macro allows you to control inputs.