Excel: Data validation dropdown macro to hide/unhide column (only one) on another worksheet in the same workbook

I'm pretty new to vba macros but I need help with a basic issue. I have a worksheet named "Setup" with a data validation list containing the options "Yes" and "No". Based on the selection "No" I would like to have a single column (say, AM) on a different worksheet named "Viewer" made hidden. If "Yes" is selected, the same column would be kept unhidden.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of April 30, 2015.

For more resources for Microsoft Excel