With the Activate() formula you can pop open the row without getting the hyperlink notification
If you want to open a row from a different table check this post: