Hints and tips home » VBA hints and tips » Suspend DisplayAlerts in VBA
Suspend DisplayAlerts in VBA
To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:
Application.DisplayAlerts = False
At the end of the procedure make sure you use the following code to reactivate Display Alerts:
Application.DisplayAlerts = True
Added by Carlos on 24th November 2006
More VBA hints and tips, like:
|
» Forum post: Visio |
Now You Can Meet And Greet Clients Without Leaving Your Desk As more of the workforce becomes home-based, online meetings and streamlining remote meeting tasks will become paramount in the quest to bring everyone together from the comfort of their desks. We find out why Microsoft Office Live Meeting 2007 is the perfect Web conferencing tool to use wherever you are. » Article: London/microsoft/training |



Course updates

