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