Hiding and unhiding column automaticaly when a cell value changes

Originally Posted by titovalle

Hello friends,

This is my first post and I think this forum has really brilliant people cooperating.

My inquirie is that I would like to create a macro in excel that can hide and unhide columns automatically when a cell value changes.

ie. When A1=pizza hide column d and show column c
When A1=burger hid column c and show column d

I want to apply this macro to a file that contains a lot of columns for each type of information.

I will appreciate any help I can get about this.

Hi,

In the worksheet tab, rightmouse and View Code, and paste this into that sheet

Please Login or Register  to view this content.

---

Originally Posted by evilrtc

I found this thread and I need something for a sheet I'm working on that is very similar. What I need to do though is hide an entire row if one cell in that row contains a certain word.

How would I modify the above code to do this?

Hi,

Try

Please Login or Register  to view this content.

will work for the A cell of the row, but I'm not sure how that fits into a thread for columns.

Do you need the code to test any other cells? - is the 'word' the only content of the cell? - you need to confirm what is required.

hth
---