Activate Ribbon Tab In Excel 2007 2010 *

**Excel Fox** · 01-07-2013, 02:34 PM

I tried the Excel 2007 version and it is working fine. For Excel 2010 file, I tried it in Excel 2010 office version and it worked too (I was pretty sure I tested this an appropriate number of times before uploading these two files).

Hope you have the latest Service Pack installed.

**flatratte82** · 01-07-2013, 07:58 PM

My version is:
Microsoft Office Excel 2007 (12.0.6665.5003) SP3 MSO (12.0.6662.5000)

**LalitPandey87** · 02-19-2013, 12:10 PM

Thanks Admin, It really helps. Thanks a lot.

**anisheco** · 12-18-2013, 06:21 PM

Hi Admin, I am new to the forum and this is my first post. Please guide me if I am not going according to the forum rules.

I have created a ribbon tab on my file and I want that tab (control id = "TabBT") to be selected once the file is opened. I would be using this file on Excel 2010 and Excel 2013. I tried several ways of doing it like, assigning a keytip and then using sendKeys (did not work). I also tried the solution given in this thread but no result.

Would appreciate any help on this and would like to learn as how do we do it. Let me know if I was not very clear.

Regards,
Anish

**anisheco** · 12-20-2013, 01:52 AM

Thank you very much.. I figured it out by looking at the very first file example you had attached. I am using Andy Pope's Ribbon Editor/Designer and it was not giving any call back option for CustomUI onLoad. I used the CustomUI editor and added that syntax. I worked fine after that.

Regards,
Anish

**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.