LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change from Column Selection to Cell Selection Lil Pun[_16_] Excel Programming 4 June 16th 06 10:38 PM
Trigger Macro on change in cell value qwerty[_2_] Excel Programming 3 April 26th 06 05:24 AM
Cell change to trigger Macro Sören_Marodören Excel Programming 2 April 11th 06 11:09 AM
Cell value change to trigger macro (worksheet change event?) Neil Goldwasser Excel Programming 4 January 10th 06 01:55 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"