Using IRibbonUI in VBA Excel 2010

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

 

[Don Guillett]

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.

Unless I'm missing something then
sheets("mytab").select
or
application.goto sheets("mytab").range("a1")

 

[Emanuele Tinari]

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")

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

 

[GS]

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

Try here...

http://www.rondebruin.nl/ribbon.htm

 

[tinoz71]

Il 25/11/2011 22.03, GS ha scritto:

Try here...

http://www.rondebruin.nl/ribbon.htm

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

 

[GS]

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

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

 

[GS]

GS made a typo, meaning to post the following:

Best wishes...

 

[tinoz71]

Finally all is OK.
tnx a lot 4 the interesting.
Emanuele