I am not familiar with your nice mouse or its buttons, but here (in
stripped-down form) is the code I use to remap the double-click event:
Private Sub Auto_Open()
'Redefine the double-click event to call the DblClick sub.
Application.OnDoubleClick = "DblClick"
End Sub
Public Sub DblClick()
'New event logic for double-click.
MsgBox "Double-click code goes here", vbInformation, "DblClick"
End Sub
Private Sub Auto_Close()
'Restore the double-click key event to normal.
Application.OnDoubleClick = ""
End Sub
To make this work all the time, put the code in a module in your hidden
Personal.xls workbook.
Please note: some Excel add-ins, such as Hyperion SmartView for Office, may
contend with you for control of the double-click event, causing errors.