Macro Tab flash

%3CLINGO-SUB%20id%3D%22lingo-sub-1482366%22%20slang%3D%22en-US%22%3EMacro%20Tab%20flash%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1482366%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20series%20of%20macros%20that%20use%20numerous%20tabs%20within%20the%20workbook.%3C%2FP%3E%3CP%3EDuring%20a%20phase%20I%20call%20reset%20for%20next%20occurrence%2C%20I%20reinitialize%20certain%20values%3C%2FP%3E%3CP%3Ethat%20are%20on%20different%20tabs.%3C%2FP%3E%3CP%3EWhen%20I%20execute%20that%20macro%2C%20the%20different%20tabs%20popup%20as%20those%20reinitializations%20are%20made.%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20see%20the%20tabs%20flash%20during%20the%20execution%2C%20just%20stay%20on%20one%20tab.%20How%20can%20I%20turn%20off%20the%20tab%20flipping%2Fflashing%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1482366%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have created a series of macros that use numerous tabs within the workbook.

During a phase I call reset for next occurrence, I reinitialize certain values

that are on different tabs.

When I execute that macro, the different tabs popup as those reinitializations are made.

I don't want to see the tabs flash during the execution, just stay on one tab. How can I turn off the tab flipping/flashing 

1 Reply
Highlighted

@Butch716 Add "Application.Screenupdating = False" at the beginning of the code, and "Application.Screenupdating = True" at the end.