Using IRibbonUI in VBA Excel 2010

  • Thread starter Thread starter Emanuele Tinari
  • Start date Start date
E

Emanuele Tinari

Excel novice programmer, want to set in code, in Sub Workbook_Open ()
present in "ThisWorkbook", then opening the file, the focus of a tab I
created with ID="MyTab".
Please specify exactly all the code. tnx in advance.
Use, as object, Excel 2010.
 
Excel novice programmer, want to set in code, in Sub Workbook_Open ()
present in "ThisWorkbook", then opening the file, the focus of a tab I
created with ID="MyTab".
Please specify exactly all the code. tnx in advance.
Use, as object, Excel 2010.
Click to expand...

Unless I'm missing something then
sheets("mytab").select
or
application.goto sheets("mytab").range("a1")
 
Il 24/11/2011 23.08, Don Guillett ha scritto:
Unless I'm missing something then
sheets("mytab").select
or
application.goto sheets("mytab").range("a1")
Click to expand...

You missing a thing: i declared i'm using Excel 2010 (the IRibbonUI is a
method of the new interface of the commandbar) so "myTab" is not a excel
workseeet as you said but a new tab, created in xml put in the ribbon of
excel 2010.
waiting 4 an answer tnx
 
Emanuele Tinari presented the following explanation :
Il 24/11/2011 23.08, Don Guillett ha scritto:

You missing a thing: i declared i'm using Excel 2010 (the IRibbonUI is a
method of the new interface of the commandbar) so "myTab" is not a excel
workseeet as you said but a new tab, created in xml put in the ribbon of
excel 2010.
waiting 4 an answer tnx
Click to expand...

Try here...

http://www.rondebruin.nl/ribbon.htm
 
tinoz71 formulated the question :
Il 25/11/2011 22.03, GS ha scritto:


I read all the pages by Ron De Bruin but i don't understand anything :-(
i'm a newbie as i wrote :-D
Click to expand...

So.., now that you have gained some really good info, it's time to put
that into practice. Ron provides numerous examples that you can study
and learn from. Also, you'll need to download a copy of the (free)
"Custom UI Editor for Microsoft Office" in order to implement Ron's
examples in your own projects. I believe Ron has a link to that on his
website.

Best wiahes...
 
Back
Top