Macro to copy and open web page

[jbk]

Right now, I have the a username on the spreadsheet (D1), user right clicks and copys then I have a hyperlink that user presses and it open a specific web page. When web page open user will right click on web page and paste user name.

What I would like a macro to do is: press the hyperlink button which both copies the hidden username and opens a specific web page. When web page is opened would paste then paste username on appropriate spot on web page.