Hello,
I'm trying to prevent users from changing data once it is
entered and saved. It's a document they will add to
repeatedly. Number of rows used each session is
variable. If a row is used and needs to disallow future
editing, there will be text in colA.

Sub protectinput()
Dim myRng As Range

With ActiveSheet
Set myRng = .Range("A:A")
If CellType = "Text" Then
????????

Don't know where to go from there. Since data does need
to be added, it doesn't make sense to protect the sheet.
or does it?? Maybe protect the whole sheet on save, then
on open unlock range defined as blank cell in colA? Not
sure how to do that either, although, willing to try if
any of you pros out there think it's workable.

Thanks in advance!