Run macro using hyperlink

**SBBmaster09** · 08-17-2016, 10:26 PM

I want to use another way from assigning a macro on my picture button.

If I click this button, it uses hyperlink and this hyperlink will run the macro, how should I do this? I need to use this way since only the hyperlink has the screentip function. I need that when I mouseover to the picture button will able to show a caption for that picture.

Either which way is simpler, just share it.

Thank you.

**karedog** · 08-17-2016, 10:53 PM

You can learn step by step tutorial (with pics) on this link :
http://www.learnexcelmacro.com/wp/20...-to-hyperlink/

**SBBmaster09** · 08-17-2016, 11:24 PM

Originally Posted by karedog

You can learn step by step tutorial (with pics) on this link :
http://www.learnexcelmacro.com/wp/20...-to-hyperlink/

I am trying to run this but still not working.

I have this shape as my button, I right click it and choose Hyperlink and reference it to A1. Then I enter the code and changed the address to A1 but still not working. Is there I missed something?

**karedog** · 08-18-2016, 03:07 AM

Ah sorry, I don't read your case carefully.
You try to set the hyperlink on a shape, not on a cell.
In this case you can follow the direction from here : http://excelribbon.tips.net/T000724_..._an_Image.html

I also have attached the sample file (with a slight modification by me) in case you want to examine it.