Suppress "Downloading..." and "Saving..." dialogues

In the macro snippet below, I run my Speedon and Speedoff macros before opening and after saving. Those two turn off all the time wasters (macros below). But in my FTELookup macro, when I open the workbooks I get a "File Downloading" message, and when saving I get a "Saving workbook..." message. How do I turn those off?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Héctor, LockWindowUpdate doesn't compile on my machine, but maybe I'm using it wrong. I pasted "LockWindowUpdate Application.Hwnd" before my "Set Lookup=,,,,: line, and put "LockWindowUpdate 0&" after "Set APR = ..."

When I try to run it, I get a Compile error, "Sub or function not defined".

It appears you didn't copy all of the code. You need the API declarations for it to work.

Rorya,
You were right, I didn't. So now, do I need to have

Please Login or Register  to view this content.

BEFORE and

Please Login or Register  to view this content.

AFTER each instance of opening and saving?

Tried it like I suggested above, for EACH instance. Didn't make any difference, sill getting the downloading and saving messages.

Yes, I've just tested and found the same, trying all sorts of window handles to lock (desktop/application/foreground). None work.

A quick search turns a few similarly frustrated people but no actual solutions, I'm afraid. I think you'll just have to live with it, as it doesn't appear to actually be an Excel window per se (application.interactive doesn't affect clicking on it for one thing).

Why are petty annoyances so annoying? I guess just to remind me I still have some growing and maturing to do. Thanks so much for taking a shot at it.