Application.ScreenUpdating = False not working swi

Question

The function Application.ScreenUpdating = False is not working whenever switching between worksheets or workbooks in Excel. This function alone worked fine in Excel 2010, but doesn't work in later versions from what I can tell. I am now using the office 365 desktop version of excel. In these later versions, the command only prevents updating when selecting cells or doing things within a specific worksheet, but for my purposes I need a form to pull data from a second worksheet which causes flickering.

Is there a way to prevent the screen from updating/flickering with SheetB briefly when it gets activated in this macro?

Sub ActivateSheetB()

    Application.EnableEvents = False 
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Sheets("SheetB").Activate

End Sub

Answer 1

I've had the same thing happen to me forever and it's fairly annoying but from my own observation, I believe that application.screenupdating = false is still working. What I mean by that is your code is still being sped up. Other than it visually being annoying and making users think they broke excel this is still an effective method for speeding up your workbook even when switching between sheets.

Hopefully someone comes along with a better answer than mine because I'd love to know what that answer is as well xD