Datsmart,
I like the idea that you've started.
Could you do the hyperlink with the screen tip and the select the "Place in the document option."
When the shape is clicked, send it to an unused portion of the spreadsheet. Then have a change selection macro that runs automatically. It's first test condition is to test to see if it is in the unused cell. If it is, then run the macro that Lerumeur really needed to run.
I think that might get around the macro issue.
Ryan