Control Tip for Shape in worksheet

Hi,

I apologize. I almost forgot you.

There is a workaround, but it is not pretty. It seems that the hyperlink (that creates the ControlTip text) takes priority over the macro assigned to the Shape 'OnAction' property. This means the macro will never run.

The workaround is as follows:
1. Add a 'SubAddress' to the Hyperlink that points to any empty cell. There are probably plenty of empty cells underneath your shape.
2. When the shape is 'Clicked' the hyperlink causes the 'SubAddress' cell to become the 'Active Cell'.
3. Add a Worksheet_SelectionChange() Event in the Sheet Module. This gets activated each time the 'Active Cell' changes. The the MACRO call is in the Worksheet_SelectionChange() code, and not assigned directly to the shape.

See the attached file that contains a working Example. Code follows here:

Lewis

In the Sheet Module 'Sheet1':

Please Login or Register  to view this content.

In ordinary code Module 'ModShapeControlTipText':

Please Login or Register  to view this content.