I have a workbook, call it File_1, for users to enter data and receive
results. During the Open event, File_1 opens a second file, File_2, that
contains confidential information used by File_1. I don't want the user to
know File_2 exists so it is hidden. However, when File_2 opens, Excel
displays a message box that reads: OPENING: File_2 with its path. I want to
suppress this message. I have tried the following code in the Open Event
section of the ThisWorkbook module of File_1:
Application.DisplayStatusBar = False
Application.DisplayAlerts = False
Application.ScreenUpdating = False
I still get the "OPENING: File_2 with its path" alert. Is there a way to
suppress the "OPENING File . . ." alert?