VBA code doesn't work when formula in sheet is removed

**Marco-Kun** · 04-16-2009, 11:23 AM

I had to remove a lot of pictures in the xls file in order to attach it, (since the original is about 5.3mb) but it worked out ..

When you move your arrow over the titles in column A a picture shows up thanks to a code. When you change the status in column G, the color changes together with the title in column A, as it should.

Please Login or Register  to view this content.

When you enter a new status at G190 till G250 it still works, as it should. But when you remove the formulas at D204:219 it doesn't work anymore. What does those formulas have to do with the code seen above? I need those formulas, so it doesn't really matter. But I was wondering if it could still work without those.

Marco

**VBA Noob** · 04-16-2009, 12:59 PM

You should be using a change event not

Please Login or Register  to view this content.

VBA Noob

**Marco-Kun** · 04-16-2009, 01:12 PM

Thanks. That worked.

Now I have another thing. When the filter is running on "Watching", as an example, and I add a new status at G190 the screen flickers for a while. It happens with whatever you do; increase or decrease an episode, or type anything at all.. This doesn't happen when the filter on status shows everything. You will see what I mean when you try it on the attachment.

**VBA Noob** · 04-16-2009, 01:14 PM

Now I have another thing

Then post another question after marking this as solved

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save