That's a creative workaround but it shouldn't be necessary !
Regards,
Peter T
"Haresh" <(E-Mail Removed)> wrote in message
news:25480A09-CAD3-4B09-8B21-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:898A6D93-055A-4BCE-A8DC-(E-Mail Removed)...
> > > 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" <(E-Mail Removed)> wrote in message
> > > > news:3543F525-7241-4E09-B885-(E-Mail Removed)...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >
|
Similar Threads
