View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel
 
Posts: n/a
Default 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.