Vba code to stop screen updating
Situation 1: When you are deleting a sheet using VBA, Excel popup a warning message.Situation 2: When you are saving a file with already existing file name, Excel popup a warning message.Here are the example codes to control the Events, Screen Updating, Progress Bar, Display Alerts and other Application Objects.This will help you to write Optimized VBA Code to fasten your code and build better VBA Macro Applications. Enable Events = False 'Do your Task 'changing combo box combo1.Status Bar = " Please wait while printing the numbers " & round((icntr / 5000 * 100),0) & "%" Next 'Make sure that you are clearing the Status bar once you are done with your task Application.Status Bar = "" End Sub Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation.Remember to set the Screen Updating property back to True when your macro ends.
This may cause your workbook to recalculate too often, which will slow down performance.
There is a word that you can use with Application that will neutralise all the alerts that Excel can send your way.