View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerold Kriechbaumer Gerold Kriechbaumer is offline
external usenet poster
 
Posts: 2
Default How to trigger a selection change between a cell and a shape

Hi NG,

I have an Excel 2000 workbook with a worksheet containing one shape which
actually is a picture.

My question: How to trigger a selection change between a cell and a shape?

1. Let's say cell "A1" is selected
2. A user then selects the shape (picture), but this does not trigger the
event "Worksheet_SelectionChange"
3. After selecting the shape the user selects cell "A1" again, but this does
not trigger the event "Worksheet_SelectionChange"
4. The user selects cell "A2", this triggers the event
"Worksheet_SelectionChange"

Does anybody know how to trigger the selection change between a cell and a
shape and between a shape and the previously selected cell?

To know the selection change from a cell to a shape is required to disable
some commands (resulting from my COM-Add-In) if a shape is selected, and
therefore avoiding a message box in many different languages that the
command cannot be executed because a shape is selected.

Thanks in advance.

Gary




---
avast! Antivirus: Ausgehende Nachricht sauber.
Virus-Datenbank (VPS): 0628-1, 10.07.2006
Getestet um: 10.07.2006 21:23:17
avast! - copyright (c) 1988-2006 ALWIL Software.
http://www.avast.com