Hi all, so I'm not very good at VBA. I have the following code and need to modify it so it only operates on the worksheet called "Trades" and not on ActiveSheet
Was hoping someone was able to point me in the right direction
Private Sub Worksheet_Calculate()
Dim ws As Worksheet: Set ws = ThisWorkbook.ActiveSheet
Dim kcell As Range: Set kcell = ws.Range("Z1")
If kcell.Value = "1" Then
ws.Range("H:L").EntireColumn.Hidden = True
ElseIf kcell.Value = "2" Then
ws.Range("H:L").EntireColumn.Hidden = False
End If
End Sub
Was hoping someone was able to point me in the right direction
Private Sub Worksheet_Calculate()
Dim ws As Worksheet: Set ws = ThisWorkbook.ActiveSheet
Dim kcell As Range: Set kcell = ws.Range("Z1")
If kcell.Value = "1" Then
ws.Range("H:L").EntireColumn.Hidden = True
ElseIf kcell.Value = "2" Then
ws.Range("H:L").EntireColumn.Hidden = False
End If
End Sub