longhorn,

Most of your request has already been answered in this post:
http://www.mrexcel.com/forum/showthread.php?t=484200