Excel Macro to hide columns in different worksheet
Posted on 2016-09-13
I have a checkbox if the user wants to display columns in a separate worksheet (the worksheet name is "BS").
The following code works to hide the columns on the SAME worksheet where the macro is called (this worksheet name is "Start Here".
If Range("C15").Value = "x" Then
Columns("C:F").EntireColumn.Hidden = False
Columns("C:F").EntireColumn.Hidden = True
How can I change this to hide / unhide the columns in the other worksheet ?