H
hoysala
i have written the following code to hide a column
can anybody help me altering the program to swap between hide and
unhide using the same CommandButton ?
Private Sub CommandButton5_Click()
If ActiveSheet.Name = SHEETNAME Then
If Worksheets(SHEETNAME).Columns("c:t").Hidden = False Then
Worksheets(SHEETNAME).Columns("c:t").Hidden = True
End If
End If
End Sub
can anybody help me altering the program to swap between hide and
unhide using the same CommandButton ?
Private Sub CommandButton5_Click()
If ActiveSheet.Name = SHEETNAME Then
If Worksheets(SHEETNAME).Columns("c:t").Hidden = False Then
Worksheets(SHEETNAME).Columns("c:t").Hidden = True
End If
End If
End Sub