ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   supress conditional formatting (https://www.excelbanter.com/excel-programming/320215-supress-conditional-formatting.html)

sai

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



All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com