0

I am new to VBA. I am using Excel 2010.

I am trying to create a new Tab (Ex:Trends) beside the existing Data tab. I want to show/Hide a 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 is there any alternative?

enter image description here

slayernoah
  • 4,382
  • 11
  • 42
  • 73
AMDI
  • 895
  • 2
  • 17
  • 40
  • 2
    Please show your code. This should include the Ribbon XML AND the VBA callbacks associated with same. – David Zemens Apr 20 '15 at 14:47
  • possible duplicate of [How to add a custom Ribbon tab using VBA?](http://stackoverflow.com/questions/8850836/how-to-add-a-custom-ribbon-tab-using-vba) – Aaron Thomas Apr 20 '15 at 14:51

1 Answers1

0

I believe this is a duplicate of "How to add a custom Ribbon tab using VBA?" - see the post with answers here.

Additionally, Microsoft Developer Network has some useful tips on this - you may check out the article "Adding Custom UI to Excel 2010 Worksheets," accessible for free on MSDN here.

Community
  • 1
  • 1
Aaron Thomas
  • 5,054
  • 8
  • 43
  • 89