Okay, after a little research I found that this should work. Forget my
other code and use this to activate another opened workbook that is NOT
your Master workbook. This works only if you have 2 workbooks open, the
one being the master and the other being the one you want activated.

Sub Test()
Dim wb As Workbook

For Each wb In Application.Workbooks
If wb.Name < "Forecast Macro Master" Then wb1 = wb.Name
Next wb
Workbooks(wb1).Activate

End Sub


Hope that works for you.

-Ikaabod


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=535966