Are you tired of annoying warnings when you open a workbook

[Jeffrey Mahoney]

Does this happen to you? I tell Excel not to display alerts about links. I open the workbook and, low and behold, a warning that it can't connect to my link!! Even though the link is in the same place on the server as it always has been, and all the formulas based on the links work just fine, go figure!!

So, I added this to temporarily not display alerts while the WB is loading. As soon as the workbook loads, one of the sheets gets activated and triggers the second sub to turn the alerts back on. If you like it, give it a thumbs up.

Put this code in THISWORKBOOK

Private Sub Workbook_Open()
  Application.DisplayAlerts = False
  Startup = True
End Sub

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
  If Startup = True Then
    Startup = False
    Application.DisplayAlerts = True
  End If
End Sub

Put this code at the top of a standard module

Public Startup As Boolean