Select ribbon tab when condition is met

**bullshot25** · 11-13-2014, 09:41 AM

Hi all,

I am trying to select a certain ribbon tab based on what business unit a user belongs to. This would mean that if a user belongs to business unit X the tab "Actions X" would be selected (the other tabs are still visible though) while a user belonging to business unit Y would get the "Actions Y" tab selected (again, with all other tabs available and visible, yet not selected). The code would look something like this I supppose, I just dont know how it would work

Thanks!

Please Login or Register  to view this content.

**Andy Pope** · 11-13-2014, 10:12 AM

This will work in xl2010 and newer.

module code

Please Login or Register  to view this content.

Sheet1 event code which allows tab activation via data validation drop down

Please Login or Register  to view this content.

You will probably have some other code to determine which tabid to activate.

ribbon xml

If you need to do this in xl2007 then you can use the approach outlined in Tony Jollan's article.
http://www.wordarticles.com/Shorts/R...bonVBADemo.php