dismiss prompts

[austin350s10]

Is there a way using VBA to dismiss prompts that excel automatically produces each time a file is opened?

For some reason "which I have no idea why" when I open my VBA project file from an online storage site I receive the following Excel messages:

If I Click "Yes" then I am presented with the following message:

After Clicking "Close" everything works fine. So basically these two message boxes mean absolutely nothing to me and the users of my form.

Is there a way to get around this?

NOTE: When I open this same file directly from my flash drive I do NOT receive any messages. It just opens the workbook like normal.

 

[repairman615]

application.DisplayAlerts = False

I think this might be it.
Set back to true at the end.

 

[austin350s10]

Thought that would work too. That's the first line in my Workbook_Open() code but it doesn't prevent these messages....

 

[mikerickson]

That message looks like it is generated before the workbook opens, thus the Application.DisplayAlerts line doesn't run before it is shown.

Also, that may not be an Excel message, it may come from the web browser.

 

[austin350s10]

That's kinda what I was thinking....just wondering if there is some other kind of workaround I have not yet thought of.

Any ideas would be greatly appreciated!