Screen flickering with conditional formating, ScreenUpdating=False and EnableEvents=False

Hi, I have a set of 5 worksheets which display CustomViews based on the content of a main worksheet (same workbook). The code is below and all is working well.

However I wanted to add some conditional formatting to the main worksheet to check for duplicates. Once I did this I get screen the screen flickering four times every time I update a cell on the main worksheet. Or more accurately every time I update a cell that is in one of the four columns that is referenced in the other worksheets that I run the code below in. Updating other cells does not cause the flicker.

I suspect the .CustomViews("Mine").Show is causing this, but can't think of another solution. Any help appreciated

Please Login or Register  to view this content.

UPDATE: the flickering made the whole thing too hard to use (both slow and annoying), so I removed the conditional formatting. When I did this I noticed that the sheet still flickers when updating the cells in question, however I believe that what I am seeing is the same thing, but without the conditional formatting it happens so quickly its hardy noticeable.

BTW I am at work and stuck using Excel 2003 too.