Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Nichole Knight   on Dec 27 In MS Office Category.

  
Question Answered By: Rocco Anderson   on Dec 27

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.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on VBA to collect double click from 'MX Revolution' mouse? Or get search suggestion and latest updates.


Tagged: