supress conditional formatting
I am seeing a lot of screen flicker even when there are no changes as
the user scrolls through the data. Either simply moving from one row
to another or making a change to a cell causes the flicker.
I have added
screenupdating=false
calculation=xlmanual
enableevents=false
at the top of all change events but I am still seeing the flicker.
Is there a way to supress computations of the conditional formatting
temporarily? or invoke it only when there is a change to cell values?
Sai
|