ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Suppress "Opening File" Alert (https://www.excelbanter.com/excel-programming/440269-suppress-opening-file-alert.html)

Palmetto955

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