View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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")