Hi there. I have a "live" online spreadsheet on our company intranet (shared with clients)
I have a parent workbook (with dashboards) that needs a second workbook (with calculations) to open in order to update all graphs.
My code is:
[VBA]
Private Sub Workbook_Open()
MsgBox ("For up to date information click OK.")
Dim book As Workbook
Set book = Workbooks.Open(ThisWorkbook.Path & "\LIVE Buzzard Anomaly Register.xlsx", ReadOnly:=True)
ActiveWindow.Visible = False
End Sub
[VBA]
It works on my computer and on a computer my colleague uses (we worked on this together) but no other computer. Any advice is appreciated.
I have a parent workbook (with dashboards) that needs a second workbook (with calculations) to open in order to update all graphs.
My code is:
[VBA]
Private Sub Workbook_Open()
MsgBox ("For up to date information click OK.")
Dim book As Workbook
Set book = Workbooks.Open(ThisWorkbook.Path & "\LIVE Buzzard Anomaly Register.xlsx", ReadOnly:=True)
ActiveWindow.Visible = False
End Sub
[VBA]
It works on my computer and on a computer my colleague uses (we worked on this together) but no other computer. Any advice is appreciated.
