By leaving the main window alone, and forcing other workbooks to become not visible, letting the code run, then bringing them back to visible, it stopped flickering. I have been experimenting with this technique, and although it doesn’t stop the flickering completely, it improves the result in an important way: It restores visibility to the Status Bar message, which I update every few seconds to show the application’s progress. Making the new output workbook invisible will crash the program during some operations, but making the macro workbook invisible after adding the new output workbook seems to suppress all but one flicker, and it preserves the Status Bar display. So I'm creating a library of commonly used macros for excel for my Excel 2011 for Mac. I'm running a couple of tests to make sure it's working properly.
In 2003, 20 doing this enables the screen to temporarily update so you get a visualization of what the sheet now looks like however in 2013 it doesn't work...
While I'm fine with experimenting with different Add-Ins, if you have a recommendation for one that suits well, it would be awesome.
An add-in not only allows you to use a macro from any instance of Excel, but you can also edit your code and add new macros to a common repository from any instance also.
Screen Updating = False ' Disable again ' Do more stuff here Application.
Screen Updating = True End Sub Activating another worksheet and then again activating the required worksheet worked for me - I had a code where the screen updating failed, I activated another worksheet and then again the one I was working on, it updated the current screen. Screen Updating = False ''''''code''''''' Thisworkbook.worksheets(any otherworksheet in workbook).activate Thisworkbook.worksheets(current worksheet).activate application.