1004 Error:VB code to restrict the use of a combobox

Hi Everyone,

I have a small problem. I've got an excel sheet with comboboxes. I've written some VB code to restrict the use of a combobox depending on the preceding selection. The problem is that the code runs fine.. But when I create a new sheet or change a sheets name I get a 1004 error. Its not even the same sheet where the code is.. Can anyone shed some light on this for me? The code is below.

Please Login or Register  to view this content.

Thanks in Advance and Enjoy your day