Hide Columns Depending on Result of a Cell

[Excelor]

Okay, I am new to a lot of this, so this may be simple.

I am looking for a formula or code that will hide columns depending on the content of a certain cell.

I found some code on an earlier post but that only worked when the cell was selected and manually changed.

What I have is a cell, say L1, that has a formula which based on the result of other cells will either return a "Y" or an "N". When this returns an "N" I want columns D:I to be hidden. When it is a "Y" the columns will be visible.

Hopefully that makes sense, hope someone can help!!

Thanks

 

[farmerscott]

Mike,

the change event given by Michael should only fire when you have "N" in L1, or if you change it.

I have Excel 2007 and is working for me. Did you have macros enabled on the other computer?

FarmerScott

 

[Excelor]

Mike,

the change event given by Michael should only fire when you have "N" in L1, or if you change it.

I have Excel 2007 and is working for me. Did you have macros enabled on the other computer?

FarmerScott

Great, I mustn't have had them enabled. Told you I was new to it all!!

Whenever I click on any cell in the sheet it seems to run it. When I switch to that sheet it has not changed but then when I click a cell, it seems to activate it.

Either way, it works how I need it to so it is spot on.

Thanks again for all this, I knew it would be simple but I am literally just starting to try and learn about visual basic and macros, etc. A brand new language to me!

Thanks all