ScreenUpdating on Excel Mac

djamieson18

New Member
Joined
Feb 4, 2012
Messages
8
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
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

vavs

Well-known Member
Joined
Jul 2, 2004
Messages
514
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

Board Regular
Joined
Feb 28, 2012
Messages
142
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,949
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top