D
David
Greetings and TIA for your time
I need your advice on the feasibility of an idea:
I'm using worksheet drawing objects as 'buttons" to run macros. I would like
to temporarily change the fill colours of the "buttons" when the mouse moves
over them before the mouse click to activate the macro. I thought that maybe
I could position an active X control behind each "button" and trigger a maro
to change button colours with the mouse move event. The control would idealy
be without any fill or lines. Also, I would need to identify the worksheet
shape object ("button") to re-color within the event handling procedure.
Maybe I colud group the control and shape object and then identify the shape
object from this association (maybe a .parent type thing)
Any advice will be greatly appreciated
I need your advice on the feasibility of an idea:
I'm using worksheet drawing objects as 'buttons" to run macros. I would like
to temporarily change the fill colours of the "buttons" when the mouse moves
over them before the mouse click to activate the macro. I thought that maybe
I could position an active X control behind each "button" and trigger a maro
to change button colours with the mouse move event. The control would idealy
be without any fill or lines. Also, I would need to identify the worksheet
shape object ("button") to re-color within the event handling procedure.
Maybe I colud group the control and shape object and then identify the shape
object from this association (maybe a .parent type thing)
Any advice will be greatly appreciated