Hiding Columns based on the value of a drop down list

Hi folks,

I'm trying to make a macro run to hide a certain column based on the value of a drop down list in Excel 2007. So far, my code looks like this:

Please Login or Register  to view this content.

but doesn't run when the appropriate cell value (E11) = TD, can someone help me here?

I wrote a quick macro to hide 2 columns and assigned it to a drop down, but when i click on the selection, it hides my entire spreadsheet...
The macro looks like this:

Please Login or Register  to view this content.

What did i do wrong?

Hope this help

How do I apply that code to the list?

I'm sorry, still not understanding, can someone please break this down for me?

Figured it out