I have a workbook_open macro that opens another workbook. It works great except when the second workbook is already open. I'm looking for a way to test for the other workbook being already open and if it is to prevent an attempt to open it again. Here's the existing macro:
Code:
Private Sub Workbook_Open()
Dim wbk As String
wbk = ActiveWorkbook.Name
ActiveWindow.WindowState = xlNormal
Workbooks.Open Filename:= _
"\\ST Budget May-06\Reference Data\STaR_Droplists.xls", ReadOnly:=True
Workbooks("STaR_Droplists.xls").Activate
ActiveWindow.Visible = False
Workbooks(wbk).Activate
ActiveWindow.Visible = True
ActiveWindow.WindowState = xlNormal
End Sub