Hello people
This might be a simple one but I'm a bit stumped and pressed for time too, so if anyone can help that would be appreciated!
I have a simle macro that hides and unhides a section of a worksheet:
Sub Button4_Click()
Columns("G:H").EntireColumn.Hidden = Not Columns("G:H").EntireColumn.Hidden
End Sub
How would I expand this such that when the button is clicked to hide the columns the button name changes to "Show Columns", and when it is clicked again to show the columns it changes the name to "Hide Columns"?
Thanks in advance
Kenny
Bookmarks