Davers
Well-known Member
- Joined
- Sep 17, 2002
- Messages
- 1,165
Hi everyone...I'd like one button that when pressed will either unhide rows if they are hidden, or hide them if they are unhidden...I can't seem to get the logic of it down...Here is my fumbling attempts so far:
Any ideas?
Thanks,
Dave M.
Code:
Private Sub CommandButton1_Click()
If Columns("H:O").EntireColumn.Hidden = False Then
Module1.unHideCol
End If
If Columns("H:O").EntireColumn.Hidden = True Then
Module1.HideCol
End If
End Sub
Any ideas?
Thanks,
Dave M.