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!!

Using a filter when sheet has VBA code
 

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
--
Gary''s Student - gsnu200822


"aimee209" wrote:

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!!

Using a filter when sheet has VBA code
 

That helps so much!
Thanks again!

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200822


"aimee209" wrote:

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!!