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

Regards,
Peter T

"Haresh" wrote in message
...
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" wrote:

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" wrote in message
...
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" wrote:

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" wrote in message
...
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