Run Code When Cell is Changed - Where am i going wrong

Hi,

I've trawled various posts and come up with some code that should change the filters on a pivot table, in a different sheet, when the user the changes a field on a sheet. All it should do is change the Year and Quarter filter on a pivot table in a different sheet when the Quarter field on this sheet is changed.

It doesn't seem to want to run though, at all - can't even step into it with F8!! Can anyone see where my code is wrong? Thanks in advance

Please Login or Register  to view this content.

Sorry, marked it as solved so someone didnt waste their time replying.

I had the code located in a seperate module, however, the code must be placed on the actual worksheet itself for it to work