ScreenUpdating on Excel Mac

[djamieson18]

Hi All,

I am using Excel Mac 2011 and it appears to be clearly ignoring the screenupdating command.

My Macro opens a new workbook and saves it as something else hundreds of times whilst taking information from another workbook which remains open the entire time. The trouble is, the screen flickers as the new workbooks are opening.

Has anyone experienced this before and can offer a solution?

Thanks,

Dave

 

[vavs]

I have just started using Excel on Mac. There are several things that I do in Excel on Windows that are simply not available. I am not sure about the screenupdating function. I would check the references and search for screen updating to see if it is available.

 

[tdh777]

Hi Dave,

I had the opposite problem where the same macro running on the PC worked perfectly but running on the Mac did NOT cause the screen to update unless I clicked on it, so I ended up doing a dodgy little "scroll screen/scroll back" at the end of my macro to ensure it worked on both platforms.

I assume you are talking about the Application.Screenupdating = false property.... perhaps just an extra one in your Macro (after some other function like saving a worksheet which might reset it to true on the Mac) would solve your problem.

If not, perhaps you could post the relevant portion of the macro on here ?

Cheers,
Warren