Vba application screenupdating false does not work

Can you post a sample file, and show us what the issue is? Windows 8 treats changing instances diferently than Windows 7 and XP.

Vba application screenupdating false does not work Sexy polish sex chat

Remember to set the Screen Updating property back to True when your macro ends.

This example demonstrates how turning off screen updating can make your code run faster.

The screen flickers and the excel macro runs slowly.

It happens when there is transition among excel files.

It sets application.screenupdating to false just before every windows (filename).activate function.

When I tried the same code on excel 2013, but Windows 8 the application.screenupdating = false stopped working only on the Windows or workbooks activate functions.To evaluate this better, can you post a sample file which replicates the scenarios you explained above?I already tried using Workbooks versus Windows and there was no difference, however the instance idea is interesting.I, like probably thousands of vba writers are now finding their Excel 2010 (or earlier) macros employing this property to suppress screen flicker (and jumping between workbook windows) now make their applications look very .With so many questions and comments since the release of Excel 2013, when this issue first occurred, there has not been an explanation from Microsoft as to why this property has been disabled and more importantly whether you accept with the level of concern a fix is required.However Windows 8 treats switching instances diferently.

Comments are closed.