Prevent double click jump to source

[Giordano Bruno]

I am using a double click to run some code. If the user double clicks an inappropriate cell, he get a message that the cursor is "out of range". If he clicks on a cell which is reading a value from another location, the code provides the message, but then selects the source cell for the formula.

I can prevent this by allowing editing directly into the cell, but I don't want this and I don't want to go into edit mode after double clicking. I can also prevent this by making the cursor select a different cell, but I don't want this either. Does anyone know how to allow the code to terminate without this irritating feature/bug?

 

[pgc01]

Hi Giordano

Did you try Cancel = True in the event procedure?

 

[Giordano Bruno]

Hi pgc01. Heartfelt thanks for that. No. That was not one of the 99 things that I had tried.

 

[pgc01]

I'm glad it helped. Cheers!