Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Function
Message
From
11/10/2000 10:44:16
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00425616
Message ID:
00427849
Views:
23
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform