shortcut for right click on sheet bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top