Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » VBA hints and tips » Stop Display Alerts In Excel
Stop Display Alerts In Excel
When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".
To stop these alerts happening use the following line of code:
Application.DisplayAlerts = False
After the Create or Delete routine use:
Application.DisplayAlerts = True
Added by Carlos on 7th November 2006
More VBA hints and tips, like:
- Count the Rows and Columns in a Selection
- Add A New Sheet at the end of the Workbook
- Stuck in a Code Loop
 |
|
» Forum post: Drop down lists |
Perfect Persuasive Publications, With Microsoft Word Michael needs to produce a very persuasive leaflet, to support a candidate in an upcoming election. Trouble is, he has next to no time to do it in - any delay will give the candidate's rivals a tremendous headstart. Fortunately, Microsoft Word allows him to produce the most stylish and effective publications within very tight deadlines. » Article: Word courses london |
How do you create drop down lists in Excel?
