Forum Discussion

SamFares40's avatar
SamFares40
Copper Contributor
Mar 14, 2020
Solved

Hiding Columns Based on a Cell Value

Hello,   I added the following VBA into the module and set B4 =0, but it wont hide column H. I am not sure why. the information is in sheet 1   Private Sub Worksheet_SelectionChange(ByVal Target ...
Macros and VBA
  • mtarler's avatar
    mtarler
    Mar 15, 2020

    SamFares40  your problem is WHERE you put that VBA code.  You put it in Module1, but the Worksheet_SelectionChange needs to be in the sheet it is meant to act on, in this case Sheet1 (expand Microsoft Excel Objects to find it).  I move it to that code sheet and it worked fine.

SamFares40's avatar
SamFares40
Copper Contributor
Mar 15, 2020

Thank you Riny_van_Eekelen!!

 

Did you use the excel sheet that i attached. In the screen shot below from the excel sheet that i uploaded earlier,  it is not hiding column "H". What am I doing wrong?

 

Thanks,

Sam

 

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Mar 15, 2020

SamFares40 Must have missed that one, as I created a new file and inserted your code. Now that I used yours it doesn't work. But, when I create a new file it does (for me at least). Attached "my" file.

 

Resources