VBA code works in excel 2003 but not 2007?

I have VBA code to force the user to select values from drop down lists when a value is selected from another drop down list. When "NONE" is selected from the first list the other lists are greyed out and set to N/A. When "USE BY DATE" is selected from the first list, the user is forced to select values from the other three lists. The code works in excel 2003 but when I run it on 2007 (at work), I get all kinds of debug errors and crashes. I am not very proficient with excel programming so I am hoping you guys can tell me why this is happening or clean up the code for me. Thanks in advance for your time and knowledge.

Please Login or Register  to view this content.

Was it really working?
You need to set the EnableEvents property to False and back to True when you change the cell value, otherwise it will loop endlessly.

i.e

Please Login or Register  to view this content.

Thank you guys! I made the changes and it works perfectly.