Thank you for the reply. Unfortunately, this doesn't do what I need. I want to only lock, for instance, A1 and A2 when something is entered into row A. When something is entered into row B, lock B1 and B2, and so on. This can be upon entry or upon save, but I need to have the remaining blank rows to be usable whenever the sheet is opened. Again, thank you for the response, I haven't been able to figure out how to get what I want it to do.