LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!!
 
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
Filter rows on sheet 2 when a certain option is chosen on sheet 1 GIP Excel Worksheet Functions 1 August 19th 10 07:48 PM
Particulars data Filter from sheet 1 to sheet 2 automatically Sudipta Sen[_2_] Excel Worksheet Functions 4 September 7th 09 04:20 PM
Unique Filter Code / Advanced Filter Fester[_2_] Excel Programming 1 October 30th 08 05:37 PM
'Copy to' Advance Filter depend only on sheet ID not start sheet Sandy Yates Excel Worksheet Functions 0 April 4th 06 03:48 AM
Can you filter sheet of data & on another sheet make four groups under each other? Marie J-son[_7_] Excel Programming 0 February 28th 06 12:12 PM


All times are GMT +1. The time now is 08:55 PM.

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"