Excel VBA Macros do not display alerts

mikanadien Posted messages 198 Status Membre -  
0kid0ki Posted messages 192 Status Membre -
Hello everyone,

I have a minor issue but it's bothering me quite a lot.
In an Excel macro, I create an "external application" object (it's not really the class of the object but at least you've understood... lol) so that from Excel, we can launch this external application by clicking on an image...

Everything works perfectly...

The minor issue I have is that since the application takes time to start, after 20-30 seconds, Excel shows me a warning pop-up "Excel is waiting for an external OLE application".

Do you have any idea of how I can stop this alert from appearing?

A display = false or something?

Thank you for your help...

Configuration: Fujitsu Siemens Esprimo Mobile 6535 in the bag

CM Asus KN8-VM + Amd Sempron 1.6 GHz 1Go of RAM at home... And that's more than enough...

2 réponses

Bidouilleu_R Posted messages 1209 Status Membre 295
 


application.DisplayAlerts=false

it is imperative to restore it to True as soon as you finish your loop, in fact as soon as possible.

you then put
application.DisplayAlerts=true

Edit
Otherwise, error messages are suppressed
4