Code to Disable/Hide "Downloading File" message box

[simon_geoghegan]

Hi All,

I have recently created a macro which opens up a number of password protected files, updates a "master" overview spreadsheet and then closes the file.

Because this macro is to be used by a team other than myself, I'd like to make it as tidy as possible, and therefore was wondering if it was possible to use code in order to "hide" or "disable" the "downloading" message that appears when you are opening files.

At the minute, this appears for each instance of a file downloading but if possible I would just like the macro to run in the background without any message boxes appearing.

I have disabled screen updating and display alerts but this hasnt resolved the issue so i'm wondering if it is at all possible or if there is some code that may help to do this.

Any help is always greatly appreciated

[gmr4evr1]

Try adding this after your Dim lines...

Please Login or Register  to view this content.

And this before your End Sub line..

Please Login or Register  to view this content.

[simon_geoghegan]

Thanks gmr4evr1, unfortunately i've attempted that already but it doesnt appear to hide that particular message for me.

It does eliminate all the other messages, just not this 'downloading' message - i suspect it wont do that because whilst 'downloading' is appearing there is no actual file to run the displayalerts on and therefore it cannot hide it.

Regards,
Simon

[gmr4evr1]

Oops, I didn't read far enough in your original post to see that you had already tried that....my bad.