I have searched the forum related to hiding & unhiding ranges, but none of the code examples/solutions have done the trick for me!
I want to be able to unhide a column in multiple sheets with the click of a button. I then have a second button which will hide these columns. Here is my code from the HIDE button:
Private Sub CommandButton3_Click()
Sheets("Do").Activate
Columns("F:F").EntireColumn.Hidden = True
Sheets("Re").Select
Columns("F:F").EntireColumn.Hidden = True
Sheets("Mi").Select
Columns("F:F").EntireColumn.Hidden = True
Sheets("Fa").Select
Columns("F:F").EntireColumn.Hidden = True
Sheets("So").Select
Columns("F:F").EntireColumn.Hidden = True
End Sub
When the button is clicked, I can see that the macro runs through the sheets (screen flashes quickly), but then Column F in each of the sheets is still visible. I am receiving no error.
May I please get some ideas?
Joe
I want to be able to unhide a column in multiple sheets with the click of a button. I then have a second button which will hide these columns. Here is my code from the HIDE button:
Private Sub CommandButton3_Click()
Sheets("Do").Activate
Columns("F:F").EntireColumn.Hidden = True
Sheets("Re").Select
Columns("F:F").EntireColumn.Hidden = True
Sheets("Mi").Select
Columns("F:F").EntireColumn.Hidden = True
Sheets("Fa").Select
Columns("F:F").EntireColumn.Hidden = True
Sheets("So").Select
Columns("F:F").EntireColumn.Hidden = True
End Sub
When the button is clicked, I can see that the macro runs through the sheets (screen flashes quickly), but then Column F in each of the sheets is still visible. I am receiving no error.
May I please get some ideas?
Joe