ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shortcut for right click on sheet bar (https://www.excelbanter.com/excel-discussion-misc-queries/57872-shortcut-right-click-sheet-bar.html)

BorisS

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

Héctor Miguel

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.




All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com