ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Suppress double click behaviour when a picture on a worksheet is active/selected (https://www.excelbanter.com/excel-programming/321541-suppress-double-click-behaviour-when-picture-worksheet-active-selected.html)

David Cuthill[_2_]

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


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com