Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
BorisS
 
Posts: n/a
Default 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
  #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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
How to get a row consecutive from a sheet to another rodante Excel Worksheet Functions 4 October 30th 05 06:20 PM
Help with Bob Phillps' UDF SheetExists Casey Excel Discussion (Misc queries) 4 October 21st 05 09:09 PM
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"