+ Reply to Thread
Results 1 to 2 of 2

shortcut for right click on sheet bar

  1. #1
    BorisS
    Guest

    shortcut for right click on sheet bar

    any shortcut for the right click action that brings up the list of sheet tabs
    (when you right click on the arrows in the lower left)?

    Thx.
    --
    Boris

  2. #2
    Héctor Miguel
    Guest

    Re: shortcut for right click on sheet bar

    hi, BorisS !

    > any shortcut for the right click action that brings up the list of sheet tabs
    > (when you right click on the arrows in the lower left)?


    not directly (I guess), but you could assign a shortcut to a macro like...
    Sub myShList()
    With Application.CommandBars("Workbook Tabs").Controls(16)
    If Right(.Caption, 3) = "..." Then .Execute Else .Parent.ShowPopup
    End With
    End Sub

    hth,
    hector.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1