Hiding Columns based on Cell value

[honger]

I have a userform that creates a new workbook, everything works but i am having hard time hiding columns based on a cell value.

If cell S2 = protocol, then i would like for column E to be hidden. How would i write this? the one below does not work for me


the code in its entirety and my issue in red font

Please Login or Register  to view this content.

[stnkynts]

protocol is a string and needs to be encased in quotes

If ActiveSheet.Range("S2").Value = "protocol" Then

Note: Also be aware of case sensitivity.

[honger]

Awesome. It was the case sensitivity.

thanks!!!!