Automaticly hide columns if certain cell has value no

Cost Tracker.xlsmHi all,

I am new to this forum because normally i can find the answers to all my excel questions without having to post the thread myself, however i am stuck here.

I am making an excel sheet for work and i have made 2 worksheets, 1 containing the lists that i would like to have in my dropdown menus, and a worksheet in where i have implemented these drowdown menus.

The sheet i am making contains a large amount of colums that a lot of times do not need to be filled out.
I have created a drowdown menu in a cell in my worksheet, based on the information in the list worksheet via data validation, list, source=REVLIST.
In order to allow my coworkers to add information to this dropdown list the following code is added to my worksheet:

Please Login or Register  to view this content.

End Sub
End If
End If





[/SIZE]

And the following code has been entered in the list

Please Login or Register  to view this content.

Now in my worksheet i would like to add a code that hides colums AO:AQ if cell AN2 = no (the no being selected from the dropdown menu)
Can anybody please help me with the code for this and how to implement it in the current change code that is already in place?

Thanks in advance.

Regards,

Robin

Hi, RobinTielens,

consider to attach a sample workbook.

Please take some time and have a read at Forum Rule #3 and add code-tags to your procedures as requested there.

Ciao,
Holger