Can you please help fix the clear button in SetUp as currently it is throwing an error
Sub Rectangle3_Click()
With Sheets("£SAFE LOG")
.Unprotect Password:="cream"
With .Range("B9:H9, B12:H12, B19:H19, B21:h21, B31:H31")
.ClearContents
.Locked = False
End With
End With
End Sub
The code in the SafeLog sheet is specifically to prevent false cell locks, in cases of empty inputs like pressing the delete key when the cell is selected
the clear button needs to work without changing the code under safe log
or
the code under safe log can change to make the clear button work without reintroducing the false cell lock issue
Thank you
Bookmarks