View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sai sai is offline
external usenet poster
 
Posts: 10
Default 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