run code when a cell is changed

I have a drop down menu for the user to select the week number they want to view. Once they select the week I want code to run that will hide all but the data from that week. I wrote the code and it works when I run it as a macro, but I don't know how to make it automatically run once the week number cell is changed. I don't want to have to tell people to select their choice from the drop down menu, and then run the macro manually. I'm sure there has to be a way to insert this code into the worksheet itself, but I am unsure as to how to write it, and where to put it. Many thanks for the help.

Here's my macro code if you're interested:

Please Login or Register  to view this content.

btw, if it matters, the cell with the drop down menu for week number is cell B1

Put the following into the relevant worksheet module and change the WS_RANGE referemce to suit

Please Login or Register  to view this content.

Dave H

I tried the code, but maybe I don't understand what you mean by change to suit. I am unfamiliar with what WS_RANGE is, so it's hard for me to figure it out. I tried putting in B1 as the range, but it pulled up a box that looked like it wanted me to save something and I could neither save, nor close out, and ended up having to force close excel.

gryffin13,

WS_RANGE is specifying the column the change event will trigger on. If your week number is in column A then change "J:J" to "A:A" or if in column L change to "L:L" etc.

Hope that helps

Dave H