Excel Zoom

Do you have a large macro that causes the screen to flash a lot? This can be avoided with two simple lines of code to insert before and after your macro. “Application.ScreenUpdating = False” goes directly before your macro commands and “Application.ScreenUpdating = True” goes directly after your commands, and before the “End Sub”.

Copy all of the code below. Paste it into your workbook’s Visual Basic editor, either under a Microsoft Excel Object or Module. Replace **Your Macro Code Here** with your macro’s commands.

Need help? Use our nifty guide to help figure out how to install and use your macros.


Sub BigMacro()
'
'MACROS BY EXCELZOOM.COM
'
Application.ScreenUpdating = False
**Your Macro Code Here**
Application.ScreenUpdating = True
End Sub