none
screenupdating = false, Excel UI will freeze RRS feed

  • Question

  • Hi, there:

    I encountered a problem with 'screenupdating = false',
    Excel will freeze.

    Have anyone encounter this problem?

    Thanks.

    Language - C#
    OS - Windows 7 64bit
    Tools - Visual Studio Ultimate 2013 + .Net Framework 4.6.2 + Office Excel 2010 64bit
    • Edited by tzengshinfu Thursday, November 17, 2016 6:34 AM add language
    Thursday, November 17, 2016 5:15 AM

Answers

  • Hi,

    Do you set ScreenUpdating = true in the end?

    We need to set it back to show the update. 

    Please visit Application.ScreenUpdating Property (Excel), you could find:

    Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

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

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by tzengshinfu Friday, November 18, 2016 8:24 AM
    Friday, November 18, 2016 7:29 AM
    Moderator

All replies

  • Hi,

    Do you set ScreenUpdating = true in the end?

    We need to set it back to show the update. 

    Please visit Application.ScreenUpdating Property (Excel), you could find:

    Turn screen updating off to speed up your macro code. You won't be able to see what the macro is doing, but it will run faster.

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

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Marked as answer by tzengshinfu Friday, November 18, 2016 8:24 AM
    Friday, November 18, 2016 7:29 AM
    Moderator
  • Hi, Celeste Li

    I forget to check the VBA reference,

    I will remember check next time.

    Thank you for the advice.


    **每天都是一滴墨水, 寫出美好未來的文章**

    Friday, November 18, 2016 8:27 AM