Hyperlink as Button for VBA Code

[LORDMARKS]

When I was researching why my command buttons keep changing size, I came accross a comment suggesting the use of hyperlinks or images instead. I like the idea of a hyperlink as it would fit better on my dashboard, but I'm not sure wher to start.

Does anyone have the method for attaching hyperlink to VBA?


Thanks as always

 

[Jerry Sullivan]

For Images or Shapes, you can right click on the object then "Assign Macro..."

I'm not aware of any similar way to assign a macro to a hyperlink.

The closest workaround I can think of would be to associate macro code through the Worksheet_FollowHyperlink event.
You can make the hyperlink target the same cell that holds the hyperlink, then execute the code in the Worksheet_FollowHyperlink procedure.