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