Printable View
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.
My version is:
Microsoft Office Excel 2007 (12.0.6665.5003) SP3 MSO (12.0.6662.5000)
Thanks Admin, It really helps. Thanks a lot. :cheers:
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
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
please the link does not work you can give me another link ??Quote:
Originally Posted by Rob Kemper
thanks
This ??Quote:
Originally Posted by klimbo123
"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 )
Quote:
Originally Posted by jhonalbert