I've figured out how to set my ranges to select those that are newly edited.
The problem I'm having now is with locking them. I want to protect my
worksheet before distributing it, and have the range to be edited as
unlocked. After edit, I want to lock only those cells that have been edited.
However, I get an error that it can't be done while the sheet is protected.
Is there anyway around this?