Using IRibbonUI in VBA 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.

Using IRibbonUI in VBA Excel 2010
 

On Nov 24, 3:42*pm, Emanuele Tinari
wrote:
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")

Using IRibbonUI in VBA Excel 2010
 

Il 24/11/2011 23.08, Don Guillett ha scritto:
On Nov 24, 3:42 pm, Emanuele Tinari
wrote:
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")

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

Using IRibbonUI in VBA Excel 2010
 

Emanuele Tinari presented the following explanation :
Il 24/11/2011 23.08, Don Guillett ha scritto:
On Nov 24, 3:42 pm, Emanuele Tinari
wrote:
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")

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Using IRibbonUI in VBA Excel 2010
 

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

Using IRibbonUI in VBA Excel 2010
 

tinoz71 formulated the question :
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

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

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Using IRibbonUI in VBA Excel 2010
 

GS made a typo, meaning to post the following:

Best wishes...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Using IRibbonUI in VBA Excel 2010
 

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