Using a filter when sheet has VBA code

  • Thread starter Thread starter aimee209
  • Start date Start date
A

aimee209

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!!
 
Can't be sure without looking at you code, but this may help both problems:

Sub dural()
Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True
End Sub
 
That helps so much!
Thanks again!

Gary''s Student said:
Can't be sure without looking at you code, but this may help both problems:

Sub dural()
Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True
End Sub
Click to expand...
 
Back
Top