vba for Excel on Mac; screen updating

[KerryFSA]

Does anyone know how to turn off screen updating in Excel VBA on a Mac?

Application.Screenupdating = False

doesn't work on a Mac. Thanks.

 

[mikerickson]

What do you mean "doesn't work".
When I use it on my Mac, it seems to work fine. Control moving back to the user interface from VBA will automatically turn it back on, but it does work while VBA has control.

What happens that leads you to think it doesn't work?

 

[KerryFSA]

When I use "Application.Screenupdating = False"
the screen flips back and forth when copying/pasting.I read awhile ago that the MacOS system design doesn't permit this function to work.
I'm wondering if anything is new in that regard.

 

[mikerickson]

I've never seen what you describe. One thought I have is that you might address Application.Calculation if there are formulas that are updating.