i realized that the procedure wasn't being called, so i created a dummy
procedure (msgbox "blah") and tried calling it. didn't work. so i
tried calling it at different points in the procedure, and they
worked.

so i discovered that there was some bug at the end of the code, and it
turns out, there was some code that i had put in to display error
messages.

i fixed up the code and now it works.

thanks again, everyone, especially you, leith. :)


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=480621