mr. kid
sudi kah kiranya menjelaskan di bawah ini, saya masih bingung plus awam

Option Explicit

Public Sub SetTimer()
    Dim lState As Long
    Dim dtNext As Date
    
    dtNext = Now()
    lState = (Hour(dtNext) + 3) Mod 4
    Sheet1.Protect "Belajar-Excel", userinterfaceonly:=True
    Sheet1.Range("i2").Locked = (lState <> 0)
    dtNext = Int(Now) + TimeValue(Hour(dtNext) & ":00:00") + TimeValue(2 - 
lState Mod 2 & ":00:00")
    Application.OnTime dtNext, "SetTimer"
End Sub

Public Sub StopTimer()
    On Error Resume Next
    Application.OnTime Now + TimeValue("00:00:01"), "SetTimer", schedule:=False
    Err.Clear
    On Error GoTo 0
End Sub


terima kasih

amin



Kirim email ke