Without seeing the rest of your code it sounds like you moved the orde
of sheets after you implemented your code, does the event happen on an
of the sheets?

Try your code in a new workbook with only one sheet if it works then i
will be the order of your sheets, i had this problem once when i added
new sheet and then put it in alphabetical order all the other sheet
stopped working!

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27102