Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change from Column Selection to Cell Selection | Excel Programming | |||
Trigger Macro on change in cell value | Excel Programming | |||
Cell change to trigger Macro | Excel Programming | |||
Cell value change to trigger macro (worksheet change event?) | Excel Programming |