Run some code on a left click

[cdb]

I have some code that I have managed to get to run when you right click in a
certain range of cells using the Worksheet_BeforeRightClick option. Is there
anyway of getting some code to work in the same range when there is a left
click??

[Harald Staff]

Not that I know of, leftclick is used by the worksheet itself to decide
where you want to go to.
You could put a transparent object from the drawing toolbar over the range
and assign the code to it perhaps ? I do that a lot.

HTH. Best wishes Harald

"cdb" <[email protected]> skrev i melding
news:[email protected]...
> I have some code that I have managed to get to run when you right click in
a
> certain range of cells using the Worksheet_BeforeRightClick option. Is
there
> anyway of getting some code to work in the same range when there is a left
> click??

[Bob]

How about using BeforeDoubleClick? This would run your code every time the
left mouse button is double clicked.

"cdb" wrote:

> I have some code that I have managed to get to run when you right click in a
> certain range of cells using the Worksheet_BeforeRightClick option. Is there
> anyway of getting some code to work in the same range when there is a left
> click??

[cdb]

I think that's the way I'll have to go - got so caught up in trying to do it
with one click I forgot all about that!!

"Bob" wrote:

> How about using BeforeDoubleClick? This would run your code every time the
> left mouse button is double clicked.
>
> "cdb" wrote:
>
> > I have some code that I have managed to get to run when you right click in a
> > certain range of cells using the Worksheet_BeforeRightClick option. Is there
> > anyway of getting some code to work in the same range when there is a left
> > click??

[cdb]

Cheers for the suggestion

"Harald Staff" wrote:

> Not that I know of, leftclick is used by the worksheet itself to decide
> where you want to go to.
> You could put a transparent object from the drawing toolbar over the range
> and assign the code to it perhaps ? I do that a lot.
>
> HTH. Best wishes Harald
>
> "cdb" <[email protected]> skrev i melding
> news:[email protected]...
> > I have some code that I have managed to get to run when you right click in
> a
> > certain range of cells using the Worksheet_BeforeRightClick option. Is
> there
> > anyway of getting some code to work in the same range when there is a left
> > click??
>
>
>

[Mark Schreiber]

I would be interested in how you set up code to run on the right click event
when a certain range is activated. I am trying to set up a spreadsheet so
that when any of a particular group of cells is activated, the contents and
formatting of that cell change. Basically, toggling back and forth between
TRUE and FALSE like a check box. However, because the spreadsheet is very
wide, I am using Group & Outline to condense it. When I tried to do this
using standard check boxes, I found that the check boxes do not stick in
place in the cells where I put them, when I collapse the group. So am trying
to make the actual cell do the job. Any ideas?

Mark Schreiber

"cdb" wrote:

> I think that's the way I'll have to go - got so caught up in trying to do it
> with one click I forgot all about that!!
>
> "Bob" wrote:
>
> > How about using BeforeDoubleClick? This would run your code every time the
> > left mouse button is double clicked.
> >
> > "cdb" wrote:
> >
> > > I have some code that I have managed to get to run when you right click in a
> > > certain range of cells using the Worksheet_BeforeRightClick option. Is there
> > > anyway of getting some code to work in the same range when there is a left
> > > click??