I am new to VBA Script. I am using excel 2010 version. I am trying to create a new Tab(Ex:Trends) beside Data tab. I want to show/Hide Tab(Trends) based on the column selected. If I select Column A,the tab(Trends) should show and if i select column B the tab(Trends) should hide.
How I can achieve the above functionality? Do we need a macro to achieve this or any alternative.