Suppress "Opening File" Alert
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? |
All times are GMT +1. The time now is 01:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com