Once you’ve drawn your shape and added text if applicable, or added an image that you want a hyperlink assigned to you can use this VBA example.
It is particularly useful to add Hyperlinks this way if the hyperlink needs to change address throughout your VBA script running.
For instance you may have a list of employees and create a PDF for each of them by VBA and within that VBA you may want them to be able to Hyperlink to another PDF with their name:
ActiveSheet.Shapes.Range(Array("Rounded Rectangle 2")).Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(1), Address:= _
"C:\Accounts\Settled\" & Worksheets("Control").Range("B13") & ".pdf"