Excel Hyperlink EXE Path help

Hi Guys new to the forum but looking to be an active member I love excel

anyways now to my problem

I have generated a sheet of hyperlinks on a my display sheet HomePage and it gathers them from =HYPERLINK(MessyCode!B1,MessyCode!A1) going all the way to 500.

each hyperlink is a unique link in MessyCode!B~ and the names are some usernames in MessyCode!A~

the problem i have the values I have to hyperlink are a network path with arguments example

MessyCode B1 is

Please Login or Register  to view this content.

this will ofcourse not launch as I hoped for =HYPERLINK(MessyCode!B1,MessyCode!A1)

IS there a way todo this? im not just missing some simple link quoteations am I? I was thinking worst case I might have to use shell to launch the path but is there a way to make cell HomePage!A dynamically launch a different link related to which A cell is clicked? the path could be determinded directly by MessyCode!B1-b500

so ideally i want HomePage
A1 Tom Jones
A2 BOb Dylan
A3 Lara Croft

to launch Shell (MessyCode!B1 Path
shell MessyCode!B2 Path
respectively as to which cell launched the vba sub

is this possible?

any helo would be very much so appreciated!

Cheers
Ash