Logitech MX Master Mouse - Tips & Tricks?

I am using the Logitech M720 Triathlon. Like the MX Master, it has a couple thumb buttons. I use the thumb buttons for forward/back in Finder and browsers, but I have mapped them to the shortcut keys for some macros I made for Word and Excel to highlight/unlight the selection.

I do lots of comparing things in one document against things in another, so the ability to quickly apply/clear a highlight is very helpful for that workflow. Here is how I do it:

In Word or Excel:

  1. Make a macro to highlight the selection and assign a keyboard shortcut to it
  2. Do the same for a macro to clear the highlight on the selection.
  3. In Word, you want to save the macro in the Normal template (Normal.dotm)
  4. In Excel, you want to save the macro in your personal workbook which usually gets created the first time you try to save a macro in it.

In Logitech Options program for mouse:
Configure the thumb buttons to send keypress events for the shortcuts you defined. Logitech Options has the ability to customize the button mapping per application.

Read on for the actual macros I use in Word and Excel 2016 for Mac. First the Excel macros:

Sub HighlightSelectionYellow()
'
' HighlightSelectionYellow Macro
' Highlights the selecion in yellow.  Made so I can assign a keyboard shortcut to be used with my Logitech mouse buttons.
'
' Keyboard Shortcut: Ctrl+Shift+y
'
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 65535
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
End Sub
Sub HighlightSelectionNone()
'
' HighlightSelectionNone Macro
' Remove Highlight. Made so I can assign a keyboard shortcut for use with my Logitech mouse buttons
'
' Keyboard Shortcut: Ctrl+Shift+g
'
    With Selection.Interior
         .Pattern = xlNone
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
End Sub

Now the Word macros:

Sub HighlightSelectionYellow()
'
' HighlightSelectionNone Macro
' Remove the highlight of the selected text
'
' Keyboard Shortcut: Ctrl+Shift+y

    Selection.Range.HighlightColorIndex = wdYellow
End Sub

Sub HighlightSelectionNone()
'
' HighlightSelectionNone Macro
' Remove the highlight of the selected text
'
' Keyboard Shortcut: Ctrl+Shift+g

    Selection.Range.HighlightColorIndex = wdNoHighlight
End Sub
1 Like