Guys,
I got a "Coach Performance.xlsm" file tI0hat is fed from \\N50K12FS01\MGI_Coach$\emedi014\Documents\My Data Sources\QA Calculator - (All LOBs) Internal Data$.odc
----
Private Sub Workbook_Open()
ThisWorkbook.Worksheets("DC").Unprotect Password:="2020"
ThisWorkbook.RefreshAll
ThisWorkbook.Worksheets("DC").Protect Password:="2020", DrawingObjects:=False, Contents:=True, Scenarios:=True , AllowFiltering:=True, AllowUsingPivotTables:=True
ActiveWorkbook.RefreshAll
Application.DisplayAlerts = False
End Sub
I got a "Coach Performance.xlsm" file tI0hat is fed from \\N50K12FS01\MGI_Coach$\emedi014\Documents\My Data Sources\QA Calculator - (All LOBs) Internal Data$.odc
Every time I open my "Coach Performance.xlsm > "DC" sheet file it should refresh with the below VBA procedure.
However, after "Refreshing All", excel automatically calls/open my source workbook. "\\N50K12FS01\MGI_Coach$\emedi014\Documents\My Data Sources\QA Calculator - (All LOBs) Internal Data$.odc "
Can anyone help me improve this code? Thanks for your assistance, ----
Private Sub Workbook_Open()
ThisWorkbook.Worksheets("DC").Unprotect Password:="2020"
ThisWorkbook.RefreshAll
ThisWorkbook.Worksheets("DC").Protect Password:="2020", DrawingObjects:=False, Contents:=True, Scenarios:=True , AllowFiltering:=True, AllowUsingPivotTables:=True
ActiveWorkbook.RefreshAll
Application.DisplayAlerts = False
End Sub