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 Suppress double click behaviour when a picture on a worksheet is active/selected

I have a worksheet that is protected except for
allowing "editting objects". I have macros assigned to
both the double click and right click events that look to
see if the target column (Column A) has been clicked on.
The problem I have is if a picture object in column A is
accidentally selected by a single left button click and a
double click is done with the cursor over the same
picture the format picture or format object form appears.
How do I suppress the presentation of the form or of this
behaviour? I need to allow the pictures to be selected
with the left button in order to have some other code to
function correctly.

I hope that is clear enough.

David