Run Two Macros from Same Button
I've searched the archives here but have not found a suitable answer for this.
I want to be able to execute two commands from the same button.
When the button is pressed once Columns B:D are hidden and when the button
is pressed again Columns B:D are unhidden.
Here's the basic macro I've recorded.
Columns("B:D").Select
Selection.EntireColumn.Hidden = True
End Sub
Columns("B:D").Select
Selection.EntireColumn.Hidden = False
End Sub
Any help would be much appreciated.
Thank you.
|