How to Hide "Opening" Excel file progress bar

[aymanm]

Hello,
The following code does NOT hide the "Opening" Excel file progress bar. It occurs when opening a 2MB Excel file in VBA code on a network server when I remotely access via VPN.

Application.ScreenUpdating = False
Application.DisplayAlerts = False

Thanks!

 

[GlennUK]

Do you mean the Excel file progress bar that appears in the StatusBar at the bottom of the screen?

What version of Excel are you using?

 

[JackDanIce]

Try:

With Application
    .ScreenUpdating = False
    .DisplayAlerts = False
    .StatusBar = False
End With

 

[aymanm]

I'm using Excel 2007 in Windows XP. The progress bar, not a Status Bar, is probably from Windows, not Excel. Can I include an attacment to show a snaphsot?

 

[MerlinXL]

If you are opening from a shared folder on the network you may want to ensure that caching options are set to No Files are available offline.

1. Right-Click on the shared folder and select Properties
2. Select the Sharing tab
3. Select Advanced Sharing
4. Select Caching
5. Select the No files or programs from the shared folders are available offline option