VBA: code to bring forward the original Workbook

[mivan]

Hi All,

I am new here and I was hoping to get help with my problem as I am at the end of my limited powers.

I have 2 Excel Workbooks online for clients to look at. One is "parent" WB (dashboard with graphs) the other one is "Data Input" WB (all information for graphs for dashboard are updated here). I am trying to have "Dashboard" with a Msg box to inform you that "Data Input" must be open. Then open "Data Input" in background.

My code:

[VBA]
Private Sub Workbook_Open()


MsgBox ("For up to date information click OK.")

ActiveWorkbook.FollowHyperlink Address:= urlpathtofileDataIput

ActiveWindow.WindowState = xlMinimized
Windows("Dashboard.xlsm").Activate
ActiveWindow.WindowState = xlMaximized


End Sub
[VBA]

I can't get it to work, it opens "Data Input" and let's it sit in front of "Dashboard". If you need more information to solve this please ask.

Hope I explained my problem correctly. Any help would be greatly appreciated.