Hi all,
I have a table, named "gloss.". I also have a macro called "summon Mendeley" that I wish to run when I double-click on columns 4, 5, 7, 9 and 11 of "gloss.". I don't want that macro to fire whenever I double click anywhere else on the sheet nor the table! I am new to excel, yet I have the impression that should be easily done! still, I couldn't get it to work!
here is the code I have now
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Target, Range("gloss.")) Is Nothing Then Cancel = True
Call summon_Mendeley
End Sub
could you, please, help me to adjust it so it can be useful for my work?
any help will be super appreciated!