Clear Log Sheets

[Billy Spivy]

Hello,

I have these codes to clear cells. Can they be altered so I can run them from another sheet called 'Switchboard'? The sheet names are 'Time Clock Log' and 'YTD Log'.

Thank you very much for your help,
Billy

Sub ClearCellsTimeClockLog()
   Dim Pwrd As String
   Dim i As Long
   
   Pwrd = InputBox("Please enter a password")
   If Pwrd <> "Fluff" Then
      MsgBox "OOPS!  Wrong password"
      Exit Sub
   End If
   For i = 3 To 126 Step 5
      Cells(5, i).Resize(396, 4).ClearContents
   Next i
End Sub

Sub ClearCellsYTDLog()
   Dim Pwrd As String
   Dim i As Long
   
   Pwrd = InputBox("Please enter a password")
   If Pwrd <> "Fluff" Then
      MsgBox "OOPS!  Wrong password"
      Exit Sub
   End If
    For i = 7 To 225 Step 9
      Cells(5, i).Resize(396, 3).ClearContents
   Next i
End Sub