Never mind, I got the last part of the question answered here:

http://www.excelforum.com/excel-form...hyperlink.html