Workbook focus when opened by another workbook

hi ,

If you're familiar with VBA you could work with variables to define your workbooks

Dim MyWb1 ' workbook 1
Dim myWb2 ' workbook 2


'asign the actual workbook to MyWb1

Mywb1 = Activeworkbook.Name

'Then if you open workbook2 asign Mywb2 to it

MyWb2 = Activeworkbook.Name


'To set the workbook active 

MyWb1.Activate

'or

MyWb2.Activate

and then you can get the workbook you need to be active .

Hope this helps.