Excel hide column formula

Closed
rimx - Jan 14, 2011 at 03:11 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 19, 2011 at 09:13 AM
Hello,

I'm trying to find a way to hide a colum in my excel workbook when I would select one of 3 drop down menu items.

The drop down list is located on top of my sheet1 and give the possibility to see my data either in infos, détails or contact

My sheet1 contains info, detials and contact data and I would just like it if I choose contact that infos and détails rows ( that I would have identified) would hide.

Thanks a lot !




1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 19, 2011 at 09:13 AM
I may have not understood your question correctly but it seems that you can use a macro to do some thing like this

columns(2).hidden=true
0