Turning off screen updating in a macro


show more Turning off screen updating in a macro provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Turning off screen updating in a macro

Other than your code not working, one of the most annoying problems that can occur when you run a macro is to have the screen flash several times. This flashing happens when your macro switches between worksheets several times. You might not be able to rewrite your code to avoid the switches, but you can add two lines of code to stop the flashing. So I'm going to open my sample file. It's called NoFlash. I'll double-click it. The workbook does contain macros, but I'm expecting them, so I will click Enable macros. I have also gone to the Excel Preferences dialog and displayed the Developer tab of the Ribbon.

So I'll click that. To run my macro, just to show you how it works and how the flashing occurs, I will click Macros to open the macro dialog, select the macro I want to run, it's called ScreenFlash, and click Run. So this macro switches back and forth between screens several times, and when it's done, it displays the word 'Done!' That type of flashing ca...

Turning off screen updating in a macro
Video duration: 3m 4s 6h 32m Beginner

Viewers:

Turning off screen updating in a macro provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...