Adding a further level of restriction to date record user input password protected cells

VinScho Hi,

You will have to use a macro and this may be a step on the way.

I have unlocked cells formatted as Home: Cell Styles: Input.

Sub protectAfterLimit()
    Dim cell As Range

    ActiveSheet.Unprotect ("prettylongpassword")
    
    For Each cell In ActiveSheet.UsedRange.Cells
        If cell.Locked = False Then
'           cell.Select
            If cell.Value = "" Then
            ElseIf cell.Value <= Now() - Range("limit_days").Value Then
                cell.Locked = True
                With Selection.Interior
                    .Pattern = xlNone
                    .TintAndShade = 0
                    .PatternTintAndShade = 0
                End With
            End If
        End If
    Next cell
    
    ActiveSheet.Protect "prettylongpassword", DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

The attached file is saved without protection.