Is there a way to detect a Left Mouse Click on a Worksheet?
Something like the event procedures "Workbook_SheetBeforeDoubleClick" for a
double
left click or "Workbook_SheetBeforeRightClick" for a right click.
Or, some other way???

Thanks.

Hi Mike,

Am Sun, 17 Jul 2011 09:27:37 -0700 schrieb Mike:

Is there a way to detect a Left Mouse Click on a Worksheet?
Something like the event procedures "Workbook_SheetBeforeDoubleClick" for a
double
left click or "Workbook_SheetBeforeRightClick" for a right click.

with left click you select a cell. Try:
Worksheet_SelectionChange


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

"Worksheet_SelectionChange" also detects any selection changes you make in
the code. Thus, I can't differentiate between a physical mouse click and a
selection change due to a code selection change.

"Claus Busch" wrote in message
...
Hi Mike,

Am Sun, 17 Jul 2011 09:27:37 -0700 schrieb Mike:

Is there a way to detect a Left Mouse Click on a Worksheet?
Something like the event procedures "Workbook_SheetBeforeDoubleClick" for
a
double
left click or "Workbook_SheetBeforeRightClick" for a right click.

with left click you select a cell. Try:
Worksheet_SelectionChange


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi Mike,

Am Sun, 17 Jul 2011 09:58:04 -0700 schrieb Mike:

"Worksheet_SelectionChange" also detects any selection changes you make in
the code. Thus, I can't differentiate between a physical mouse click and a
selection change due to a code selection change.

you can stop any event by code selection change with:
Application.EnableEvents = False
At the end of code you have to turn to TRUE


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks Claus !

"Claus Busch" wrote in message
...
Hi Mike,

Am Sun, 17 Jul 2011 09:58:04 -0700 schrieb Mike:

"Worksheet_SelectionChange" also detects any selection changes you make
in
the code. Thus, I can't differentiate between a physical mouse click and
a
selection change due to a code selection change.

you can stop any event by code selection change with:
Application.EnableEvents = False
At the end of code you have to turn to TRUE


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2