still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 826
- Office Version
- 365
- Platform
- Windows
Hi
I want to put a button on the ribbon that will hide and unhide column. I don’t need a password.
I want it to toggle each time I click on it
First click>>unhide
second click>>hide
mike
I want to put a button on the ribbon that will hide and unhide column. I don’t need a password.
I want it to toggle each time I click on it
First click>>unhide
second click>>hide
HTML:
Sub unhide()
Columns("a:a").EntireColumn.Select
Selection.EntireColumn.Hidden = False
End Sub
HTML:
Sub hide()
Columns("a:a").EntireColumn.Select
Selection.EntireColumn.Hidden = True
End Sub
mike