I'm confused. Why not just select the cells in which the hyperlinks reside, go to "format cells">"Protection">uncheck "Locked", then protect the sheet, only leave "select unlocked cells" checked?

That way the only cells they can click on are the ones that hold the hyperlinks.

I don't think a macro is necessary here.