Activate Ribbon Tab In Excel 2007 2010 *

**Excel Fox** · 02-26-2012, 02:48 AM

Check the attachment...

**philipb645** · 02-27-2012, 08:42 PM

I've attached my sample project. It has a menu which shows on the add-ins tab. With your code, I can't seem to give focus to it. I'm sure I missing something easy.

**Rob Kemper** · 09-28-2012, 03:06 PM

Hello,

How To Activate A New Ribbon Tab.xlsm
This is the example that I tried in Excel 2007.

You asked me to start a new thread but the button to do so is not available. According to manual I do not have the rights probably. I have registered.

If you open the example it creates the custom tab but gets an error 91 because the ReturnElement has value Nothing and cannnot call its method. In my opinion this is caused because GetAccessible does not find the custom tab in the control tree.

Can you look into this example in spite of the fact that I did not create a new Thread?

Thanks

Rob Kemper

**klimbo123** · 01-22-2019, 02:55 PM

Originally Posted by Rob Kemper

Hello,

Attachment 394
This is the example that I tried in Excel Tutuapp 9apps Showbox 2007.

....

please the link does not work you can give me another link ??
thanks

**DocAElstein** · 01-22-2019, 05:05 PM

Originally Posted by klimbo123

please the link does not work you can give me another link ??
thanks

This ??
"How To Activate A New Ribbon Tab.xlsm" : https://app.box.com/s/h7om86vsnnsync61skxsb5npi8lllck6

Alan

( from post #6 :
"How To Activate A New Ribbon Tab 2010.xlsm" : https://app.box.com/s/ffvd87cvbz2qny3w5encd4hb8is893s4 )

Originally Posted by jhonalbert

Easily activate ribbon tab by Click the Ribbon Display Options icon on the top-right corner of your document. It is to the left of the Minimize icon. In the menu that opens, click Show Tabs and Commands to show the Ribbon with all tabs and full commands.