I have this macro:
I'd like to add a 2 second delay after the above code is executed, then add the following code:Private Sub Workbook_Activate() On Error Resume Next Application.DisplayAlerts = False End Sub Private Sub Workbook_Open() On Error Resume Next Application.DisplayAlerts = False End Sub
How could this be done? ThanksActiveWorkbook.RefreshAll
Bookmarks