Sounds like events may be turned off.

Try adding this to the end of the code

Application.EnableEvents = True

and also type that statement in the immediate window.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tweety127" wrote
in message ...

hi bob,
just a question...
why is it when i save the file containing the code you sent me and
tried to open it again, the code doesn't work anymore....


--
tweety127
------------------------------------------------------------------------
tweety127's Profile:
http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=568006