![]() |
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 |
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