MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Annoying Pop-up Dialogue Boxes


Posted by Kevin on January 29, 2001 9:10 AM

I created a template that has links to information in other workbooks. How do I let the computer automatically update the links wothout having that stupid screen keep popping up?


Posted by John L. on January 29, 2001 10:31 PM

Kevin, try this:
Application.DisplayAlerts = False

Posted by Kevin on February 07, 2001 2:45 PM

I tried both of these

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

Private Sub Workbook_WindowActivate(ByVal Wn As Window)
Application.DisplayAlerts = False
End Sub