View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aimee209 aimee209 is offline
external usenet poster
 
Posts: 18
Default Using a filter when sheet has VBA code

My workbook has several tabs that have a short code that changes the font
color if the processing date is more than 30 days old and whether is was
processed successfully. When the filters are not being used, it works fine.
But when the filters are used, everytime you click, there's a 2 second delay
and horizontal lines scroll through the screen. Is there any way when the
filter is on that there isn't a pause or screen flashes?

Thanks!!