View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Cuthill[_2_] David Cuthill[_2_] is offline
external usenet poster
 
Posts: 17
Default Macro doesn't perform correctly when using right click menu

I have a macro that I have tied to execute when the INSERT
key is pressed on the keyboard that I have also tried to
have run by creating a menu item on the right click menu
for a shape. The right click menu method does not give me
the same result as the INSERT key method.

Essentially the macro is run once a picture on the
worksheet is selected by first selecting the picture with
a left mouse click and then pressing the INSERT key. The
macro then places another picture immediately below the
selected picture.

If I select the picture using the left mouse click and
then press the right mouse button and select the insert
menu item I created (that calling the INSERT key macro)
the new picture does not get inserted below the original
picture but rather in another location or I get a message
telling that the object does not support that property.

The only thing I can think is happening is that by making
the right mouse selection I somehow am loosing "focus" of
the original picture which then messes things up.

Has anyone experienced a similar situation???

David