Macro to copy and open web page

Thanks for the reply... I want a macro that copys username in "B1" and opens desired website. In this case I used ExcelForum.com (see hyperlink in C1) User then can paste username on desired field on web page. Using the sample attached, the user would have to copy the username found in "B1", then hit the hyperlink in "C1", allow webpage to open the paste. I simple trying to eliminate or the first step of user having to copy username found in "B1" and have a macro that would copy when the hyperlink or similar is pressed.

Also, I would like the Username found in "B1" to be hidden but editable if necessary.

Sample.xls