Forum Discussion
Autohide
Im trying to make columns autohide if row 1 = 0. Any ideas?
Hi Thomas,
I believe you can not do that unless you use Macro, or VBA.
this code will help:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value = 0 Then
Columns("A").EntireColumn.Hidden = True
Else
Columns("A").EntireColumn.Hidden = False
End If
End Sub
I believe you can not do that unless you use Macro, or VBA.
this code will help:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value = 0 Then
Columns("A").EntireColumn.Hidden = True
Else
Columns("A").EntireColumn.Hidden = False
End If
End Sub