Office 365 - Excel Macro - Toolbars Blink

[ststern45]

Hello everyone,

Just updated to Office 365 from Excel 2010. Actually have both versions on my computer which is a Dell Inspiron 530 purchased back in 2009 32 bit.

OK, here is my question.

I opened an old Excel 2010 file .xlsm with macros enabled using Excel Office 365.

So far so good.

I clicked the Toolbar that updates the data but noticed the Toolbars blink/disappear while the macro runs. Is there a fix to this?

Or is the code below causing the blinking of the toolbars?

Application.ScreenUpdating = False

Application.ScreenUpdating = True

Thanks

Steve

 

[GJSBED]

Is it set for...
Application.ScreenUpdating = False

In which case there shouldn't be anything happening on screen.

But memory use might be causing the disapearing toolbar, i presume it comes back when the macro is done?