autoshape with macro changes colour when clicked

[Haresh]

Hi everyone!

i am using an autoshape (rectangle with rounded conrnes) instead of a
command button. i have given it a very creative look. its clolour is
formatted to give a two colour fill effect. there is a macro assigned to its
click event.
now the prob is that when the user clicks on it. its color changes from
yellow to dark blue and spoils the whole appearance. if this happens then my
whole creativity and my time will be a waste and i will have to go back to
traditional command button is there any way to get around this please.

any help will be much appreciated
Thanks very much
Haresh

 

[Peter T]

Hi Haresh,

AFAIK you cannot change that behaviour. However why is it a problem and why
does it spoil your creativity. It provides useful feedback to user to
indicate the shape is pressed and will fire a macro if user releases mouse
while still over the shape, or could abort by dragging mouse off the shape
before releasing.

Regards,
Peter T

 

[Haresh]

Hi Peter, Thanks for replying so quickly. actually some behaviour of the
autoshape to indicate that user is clicking it will be an added advantage.

but the problem is that the colour changes to dark grey, bit green, blue
(cant even describe the colour as it is some unknown mixture) this is what
spoils the appearance. furthermore this change in colour is not temporary, it
stays even after the click event is completed. that means even after the user
has clicked it, the shape doent not return to its original look.
also the colour changes even when the user has clicked and dragged away to
abort the macro.

thanks for your help!
Regards
Haresh

 

[Peter T]

furthermore this change in colour is not temporary, it

stays even after the click event is completed

Really, that hasn't occurred with me. Colour(s) should shift by 50% hue when
the mouse is down and revert to original when the mouse is released.

Copy your shape and assign to a very simple macro, just a msgbox. Does that
work as expected.

Regards,
Peter T

 

[Haresh]

Hi Peter, not sure why my excel was behaving such. but i have now overlapped
the autoshape with another not formatted shape and made it transparent and
assigned the macro to not formatted shape intead of formatted shape and now
its working is as i had expected but with a bit of cheating.

anyways,
Thanks very much for help
regards
Haresh

 

[Peter T]

That's a creative workaround but it shouldn't be necessary !

Regards,
Peter T