Did you put the code in the ThisWorkbook code module?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jerrystan" wrote
in message ...

Thanks guys, but I'm still getting an error. Could my other macros in
this file be affecting it??


--
jerrystan
------------------------------------------------------------------------
jerrystan's Profile:
http://www.excelforum.com/member.php...o&userid=28573
View this thread: http://www.excelforum.com/showthread...hreadid=494190