Hi All,

I am new to using macros. When I say new, I’m talking in the past 2 weeks, so any help would be great.

I have Microsoft Excel 2010, and I have created a spread sheet with 17 columns (A – R) and 95 rows. In the entire column D, there is a dropdown list that I created using Data Validation. It lists down the words Yes, No and call back.

What I need is when you click in any cell in column D, and choose either No or Call Back from the drop down list, that columns E trough to K will be hidden, and when you choose Yes from the drop down list these columns will be unhidden. Also how can I protect and unprotect using code?

Can you please help? I tried many times but not successful. Appreciate if someone will be able to walk me through how to do this. Thanks a lot. Nephi.