Hide columns based on value

[LeonvL]

Why can't I get this to work?

Just want to automatically hide each column (from E to W) that has a capital X in row 3....

Please Login or Register  to view this content.

[JOHN H. DAVIS]

You have your loops off

Please Login or Register  to view this content.

[JOHN H. DAVIS]

You're welcome.

[LeonvL]

Ooops. Thanks John...
Nonetheless it's still not working. Seems that all events are not working..?!?

Tried Application.EnableEvents but doesnt make any difference...

Please Login or Register  to view this content.

[JOHN H. DAVIS]

It worked when I tested it. Do you have a sample you can provide. It triggers when a cell in row 3 is selected.

[LeonvL]

John, I have attached the file with the sample code

[JOHN H. DAVIS]

Maybe I don't understand, but it works on your sample as well. Perhaps you want to trigger it when you put data in row 4 instead?

Please Login or Register  to view this content.

[LeonvL]

Well, yes

So then I may need to use Calculate, like this:

Please Login or Register  to view this content.

But it doesnt work either...

Basically, what my intention is: The column containing an "X" is the result of a formula based on things happening on another sheet.
So when that changes, the column header in row 3 turns into "X" and the column will be hidden.

[JOHN H. DAVIS]

The formula you have in row 3 in your sample gets the "X" from input into row 4. Do you want just the activecolumn hidden or all columns hidden based on the input?

[LeonvL]

I have simplified it a bit in the sample sheet.
When the value in a certain column in row 3 changes I want only that certain column to be hidden.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.