LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Supress rows AmyLRuck Excel Discussion (Misc queries) 5 October 5th 08 10:49 PM
Supress #Ref! error Mike H Excel Worksheet Functions 3 May 3rd 07 08:24 PM
how do I supress text in a column? Supress Repeating values in a column Setting up and Configuration of Excel 1 November 16th 05 11:37 PM
#div/0! how do i supress? vipa2000 Excel Worksheet Functions 5 July 31st 05 08:34 PM
supress Solver message PB Excel Programming 0 November 19th 03 02:29 PM


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"