| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 | Excel Discussion (Misc queries) | |||
| Suppress "File conversion in progress" message box | Excel Discussion (Misc queries) | |||
| Prevent "Opening..." alert when opening from VBA | Excel Programming | |||
| METHOD "SELECT" OF OBJECT '_WORKSHEET' FAILED when opening a file | Excel Programming | |||
| within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming | |||
Linear Mode
