Hyperlink to run macro not working

Hello everyone! I've scoured the Internet for solutions to this for quite some time over the past few days, and I've tried employing solutions I've found suggested for other people but cannot seem to get any of the examples to work once I modify them.

Basically I have tried writing the below formula in Row 2, Column R of my spreadsheet and I have filled the formula down all of quite a few rows of column R:

Please Login or Register  to view this content.

I have a public sub in this same worksheet named "CopyPersonnelData()", which places some data in cells of another worksheet based on some values in the active cell row, and then this sub calls a module named "SendEmail()", which composes an email in Microsoft Outlook.

My CopyPersonnelData() and SendEmail() subs work just fine, but I cannot find a way to successfully call the CopyPersonnelData() via a hyperlink. I have over 200 rows of data, so dynamically creating a hyperlink based on the value of another cell the way I've tried doing would be the best approach... because not every row needs ability to call the CopyPersonnelData() sub... only if the value in Column J of the same row is <60.

Any good solutions for how to do this, without creating a hyperlink to unnecessarily open a webpage or a local file/path? Thanks so much!!!