Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using IRibbonUI in VBA Excel 2010
Finally all is OK.
tnx a lot 4 the interesting. Emanuele |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM | Excel Worksheet Functions | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming | |||
IRibbonUI error | Excel Programming |