I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”.
Unfortunately, I have to maintain hundreds of Excel applications each with thousands of lines of code and hundreds of users who are about to migrate to Office 2016, so rewriting is not an option. I wanted to leave a comment but I am not allowed to do so.
I'm running a couple of tests to make sure it's working properly.
The biggest problem I'm running into is that when I run the code (despite having Screen Updating set to False), it visibly opens the library file while it runs the macro.
Screen Updating is turned on outside of the procedure.
- Try this at the beginning of your procedure: This solved my flicker problem, but I didn't like how the excel application disappeared completely then suddenly reappeared for the user.
Whenever you have a task to automate, you can usually go down the VBA route. Maybe later you add some features here-and-there, making your VBA code more powerful. Color = vb White End If i = i 1 Next cell ' offset i to alternate column coloring i = i 1 Next repeat Msg Box "Total time was: " & (Timer - start Time) End Sub Before moving on, let’s get a better understanding of why this is taking so long. Color = vb White End If i = i 1 Next cell ' offset i to alternate column coloring i = i 1 Next repeat Msg Box "Total time was: " & (Timer - start Time) Application.
Excel will default save it to your add-ins directory.
Screen Updating = True ' Enable to refresh screen Application.
Screen Updating = False ' Disable again ' Do more stuff here Application.
Also, any chance you know what the difference is between link and my own situation is in regards to the answer by Alistair Weir? I'm not talking about an add-in for you to get, you can save your VBA code as an or from the saveas drop down list.
While I'm fine with experimenting with different Add-Ins, if you have a recommendation for one that suits well, it would be awesome.