Macro Buttons explanatory text?

Hello kyrgyzstanart,

Add a hyperlink to your shape and hyperlink to cell behind the shape. Set the screen tip to display what you want when the mouse moves on to the shape.

Originally Posted by Leith Ross

Hello kyrgyzstanart,

Add a hyperlink to your shape and hyperlink to cell behind the shape. Set the screen tip to display what you want when the mouse moves on to the shape.

Hello Leith Ross,

Thank you for the tip, but it doesn't work. When the button gets a hyperlink - when I click on the button it doesn't run the macro assigned to it but simply sends to the cell "behind the shape.

Here is what I found at http://excel.tips.net/Pages/T003294_..._an_Image.html

"You might at first think that you could add a ScreenTip to the image, but that can only be done if you assign a hyperlink to it. Adding the hyperlink (and ScreenTip) is easy enough, but you'll find that the hyperlink takes precedence over the macro, stopping it from being run."

But their way is not the most streight forward, I was wondering if somebody on the forum has done something like this.

Please, advise.

Try it out, tell us how it goes.

Another option could be a Hyperlink Macro,
http://www.excelforum.com/excel-prog...-question.html

Click Here for an Example

What you could use is the Comment of the Cell beneath.

Please Login or Register  to view this content.

and in Module1

Please Login or Register  to view this content.

see My atachement and hoover over CB1.