Mar 06 2023 01:07 PM
Hello,
i need help if someone know how to lock or unlock specific cell soo users can write ther only in certains date. or if you know other program where to do it...
Thnx
Mar 06 2023 01:37 PM
Select cells you want to unlock. Right-click and select "format cells"
Go to Protection tab and unselect "Locked"
Mar 06 2023 01:41 PM
Mar 06 2023 01:50 PM
This will take several steps.
Step 1: Unlock cells.
Step 2: Protect the worksheet.
Step 3: VBA code.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
With Worksheets("Sheet1")
.Unprotect Password:="Secret"
.Range("C2").Locked = True
.Protect Password:="Secret"
End With
End Sub
Private Sub Workbook_Open()
With Worksheets("Sheet1")
.Unprotect Password:="Secret"
.Range("C2").Locked = (Date <> #3/6/2023#)
.Protect Password:="Secret"
End With
End Sub