Forum Discussion
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 ...
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 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.
Thank you so much mtarler
