Results 1 to 4 of 4

Thread: Sort data sheet by right_click of mouse

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Apr 2011
    Posts
    190
    Rep Power
    15
    This modification will result in the right_click options for sorting is only shown when the HeaderRow has focus

    Code:
    Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
        If Target.Row = HeaderRow Then
                AddOnRightClick
            Else
                DeleteOnRightClick
        End If
    End Sub
    xl2007 - Windows 7
    xl hates the 255 number

  2. #2
    Junior Member
    Join Date
    Dec 2012
    Posts
    3
    Rep Power
    0
    Really good

Similar Threads

  1. Sort Data Using Formula To Find Top X
    By mahmoud-lee in forum Excel Help
    Replies: 12
    Last Post: 06-02-2013, 10:13 PM
  2. Replies: 6
    Last Post: 05-10-2013, 01:13 AM
  3. Replies: 2
    Last Post: 12-26-2012, 08:31 AM
  4. Excel Macro to Sort Data if a value changes in defined range
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 09-05-2012, 10:31 AM
  5. Sort Data When a Header Is Clicked
    By Rasm in forum Excel Help
    Replies: 9
    Last Post: 08-01-2012, 06:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •