Code to change shape colour with mouse hover

hi,

does someone know code to change shape colour on mouse over and then revert back when mouse off. need to able to add a hyperlink to another part of the workbook.

thanks

Hi lorettag1966,

Great question, that requires some trickery to solve your problem. The solution is courtesy of Andy Pope circa 2003: http://www.ozgrid.com/forum/showthread.php?t=17212

There are no 'Shape' mouse events. I had to cover the 'Shape' with two transparent 'Active X' Labels:
a. Active X Label1 is on top of the Shape and is slightly larger than the shape.
b. Active X Label1X is behind the Shape and is slightly larger than Label1.

When a Label1_MouseMove() event occurs, the Shape can be colored.
When a Label1X_MouseMove() event occurs, the Shape can be colored again (back to the original color).

The only code involved is the Sheet mouse event code:

Please Login or Register  to view this content.

See the attached working sample workbook.

Lewis

thankyou...works a treat.