Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Function
Message
De
11/10/2000 10:44:16
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00425616
Message ID:
00427849
Vues:
21
Tamar and Della,

FWIW, below is the help text from VBA 8. The text is rather confusing as indeed it mentions "while a macro is running". However, I can confirm that it works properly under Excel 97. My guess is that the behavior changed in Excel 97 as indicates the section "This behavior is different from previous versions of Microsoft Excel..."

Great book and the CHM file is very handy!

DisplayAlerts Property:

True if Microsoft Excel displays certain alerts and messages while a macro is running. Read/write Boolean.

Remarks

The default value is True. Set this property to False if you don't want to be disturbed by prompts and alert messages while a macro is running; any time a message requires a response, Microsoft Excel chooses the default response.
If you set this property to False, Microsoft Excel doesn't automatically set it back to True when your macro stops running. Your macro should always set the property back to True when it stops running.

Note This behavior is different from previous versions of Microsoft Excel. In earlier versions, the DisplayAlerts property was automatically reset to True
when the macro stopped running. If you have old code that relies on this behavior, you should change your code to explicitly set the property back to True at the end of the macro.
Daniel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform