We are noticing an odd behavior with Application.ScreenUpdating in Excel 2013 as it pertains to multiple workbook scenarios.

With Application.ScreenUpdating = False, performing actions on other non-active workbooks causes Excel to "focus" the target workbook resulting in a momentary screen flash.

For example, if Book1 is active and we attempt to set visibility on Sheet1 of Book2, the screen will flash as Book2 is focused and the visibility method executed.  Afterwards, focus is returned to Book1.

This happens on other operations as well - such as protect, unprotect, etc.

It appears to us, that with the introduction of SDI in Excel 2013, ScreenUpdating is not completely disabling all screen updates as it has with previous Excel releases.

Any help would be really appreciated.

Thanks!

You should turn ON ScreenUpdating  after your code is running.

with applications
   .ScreenUpdating  = false
    'your code....
   .ScreenUpdating = true
end with

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

• Edited by Excel In Texas Monday, November 11, 2013 1:18 PM

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

• Edited by Excel In Texas Monday, November 11, 2013 1:18 PM

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

• Edited by Excel In Texas Monday, November 11, 2013 1:18 PM

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

• Edited by Excel In Texas Monday, November 11, 2013 1:18 PM

I believe that's what I described in my original post.  I set ScreenUpdating = false DURING code execution.

It is with screen updating OFF, and VBA (not the user) manipulating various workbooks/worksheets that we experience the anomalies. 

• Edited by Excel In Texas Monday, November 11, 2013 1:18 PM

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 7 hours 6 minutes ago

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, November 21, 2013 4:52 AM

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, November 21, 2013 4:52 AM

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, November 21, 2013 4:52 AM

Hi,

I tested the code which posted in the thread in my computer. It worked normally and did not switch the workbooks.

My tested environment:

OS: Win8 Office 2013.

If your environment have difference with mine,please tell me.

And the issue seems more related to VBA code/programming, I recommend you post the question in MSND forum

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Thursday, November 21, 2013 4:52 AM

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,

I'm marking the reply as answer as there has been no update for a couple of days.

If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by Dean Meyer Friday, February 21, 2014 4:36 PM

• Edited by Dean Meyer Friday, February 21, 2014 4:36 PM

• Edited by Dean Meyer Friday, February 21, 2014 4:36 PM

It may work on Windows 8 and Office 2013, but code which has been running on windows 7 , office 2007 and office 2010 doesn't work. The screen may stop updating but when the macro finishes I have found you aren't left with the approriate sheet on top and excel seems to want to display all sheets that have changed. So teh problem hasn't erally been answered.

I also see exactly the same behaviour on my system.

Code is running well on machines running WIN7+Office 2010 but on my
development system with WIN7+Office 2013 the screen flickers at each switch.

And the problem is that a workbook which is opened to serve as a source for a dropdown
field in a userform overlays the userform when opened which doesn't happen with Office 2010.

Im my oppinion this thread isn't answered because the majority of the systems running in offices
are WIN7+Office 2010 and will be switched to WIN7+Office2013.

To have WIN8+Office 2013 which works obviously well will take a while if it ever happens...

So it would be nice to have a solution or a workaround.

...

So it would be nice to have a solution or a worka

...

So it would be nice to have a solution or a worka

Bump,

Does anyone know how to resolve this behavior?

Windows 7, Office 2013, Excel 2013

A VBA process runs, in my case drawing a chart, and then shows the chart to the user. 

It takes a very long time for the chart to appear. For the remarkably patient, it does finally appear.
I have userform.Show 0 controls that allow the user to modify the chart. After said modification, the screen does not update. Closing the userform, clicking on the chart have no impact.
To get the chart to update, Close the userform, switch to another tab, Then switch back to the original tab. And you can see the changed. 

I have paying clients.
Microsoft, what am I supposed to do, tell them this is a design feature? 

Note: Workaround for some situations, add:

    Application.screenupdating = True
    ActiveSheet.Next.Select
    ActiveSheet.Previous.Select

This does achieve the desired screen refresh. (might want to throw in a doevents in there too)

However in some instances, due to event procedures, this is not valid option.

Please, anyone.... HELP!

• Edited by 0rangeCru5h 17 hours 53 minutes ago

Bump,

Does anyone know how to resolve this behavior?

Windows 7, Office 2013, Excel 2013

A VBA process runs, in my case drawing a chart, and then shows the chart to the user. 

It takes a very long time for the chart to appear. For the remarkably patient, it does finally appear.
I have userform.Show 0 controls that allow the user to modify the chart. After said modification, the screen does not update. Closing the userform, clicking on the chart have no impact.
To get the chart to update, Close the userform, switch to another tab, Then switch back to the original tab. And you can see the changed. 

I have paying clients.
Microsoft, what am I supposed to do, tell them this is a design feature? 

Note: Workaround for some situations, add:

    Application.screenupdating = True
    ActiveSheet.Next.Select
    ActiveSheet.Previous.Select

This does achieve the desired screen refresh. (might want to throw in a doevents in there too)

However in some instances, due to event procedures, this is not valid option.

Please, anyone.... HELP!

• Edited by 0rangeCru5h Friday, September 19, 2014 5:08 PM