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.
|