Screenupdating true

15-Apr-2020 23:57

taduh If you leave screen updating off until you after you have restored the control tab you should not see any flashing of undesired content. Echo is an Access command, it doesn't work in Excel.

Kevin You don't need to activate the tabs or access their command bars to refresh data.

You can't avoid flashing altogether, but if you leave screen updating off until after you have restored the control tab, it should be minimal.

Still, any ideas why the Screen Updating = False doesn't work when I select a different sheet? Is it because the selection was performed in a different sub?

Could this be causing the application.screenupdating zorvek, I need to activate the tabs, because I need to access their command bars in order to refresh the data on the report.

Even if I restore the control tab before turning screen updating back on, wouldn't there still be a flash to the report tab while it's activated?

Once we use at the end of the code, it will revert to the default Excel message which is READY.

Display Alerts = True End Sub You can see the code posted in the module below - Now lets understand what each line of the code does - So first we set DISPLAYSTATUSBAR to true and then we set the message for the status bar.

Still, any ideas why the Screen Updating = False doesn't work when I select a different sheet? Is it because the selection was performed in a different sub?

Could this be causing the application.screenupdating zorvek, I need to activate the tabs, because I need to access their command bars in order to refresh the data on the report.

Even if I restore the control tab before turning screen updating back on, wouldn't there still be a flash to the report tab while it's activated?

Once we use at the end of the code, it will revert to the default Excel message which is READY.

Display Alerts = True End Sub You can see the code posted in the module below - Now lets understand what each line of the code does - So first we set DISPLAYSTATUSBAR to true and then we set the message for the status bar.

And then put a debug.print before/after each line (including before after the select line). and then put a debug print after the called sub ends and the code returns to the original sub. Well that narrows it down to the selecting I guess, and I guess further that it's specifically the selection of a sheet that wasn't the active sheet when you launched the macro.