When the main macro runs it show all the process from the biggining not in the end of macro. If the next called macro (macro3) doesn't turn screenupdating off again, you will see everything it does because screenupdating is still on because of macro2.
And why the 2nd macro (in other workbook) runs perfect with or without Screenupdating =true ? If you then call another macro (macro2) that turns it back on, you will see the screen refresh at that moment.
Screen Updating=false is not working Here is my code: Application. If macro3 does turn screenupdating off but then turns it back on at the end, you'll see the screen redraw then. Simply removing Screenupdating = True from all the macros should resolve that. If your question is answered then please remember to mark it solved Computers are like air conditioners. - still, I have that flickering with excel 2013-W8 and not with excel 2010-W7 since the main sub (and those called by it) has to open all those many workbooks, for reading data inside them, I'm starting to think flickering is due to this.but with no idea of why should that happen with excel 2013-W8 only.You could try the technique proposed by Excelerator_Marc in this thread (last post in thread).
Screen Flicker - EXCEL 2013 Only Just in case MS does something with there forum posts as they often do, here is his proposed work-a-round.thank you Tn Tin MN so it turns out it is actually an Excel 2013 issue...
The example hides every other column on Sheet1, while keeping track of the time it takes to do so.
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.
well that's both reassuring and frustrating at the same time.
Hello experts i have this macro (which calls macros in other workbooks) and the Application.
within the Excel Questions forums, part of the Question Forums category; Hi, For some reason Application.