View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Switching between sheets in same workbook (Like Alt + Tab & Choose

How about a sheet navigation toolbar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I like best, but that's me<g

See this google search result. All one line for the URL

http://groups.google.com/group/micro...c19464f875bd25



Gord Dibben MS Excel MVP

On Fri, 16 Apr 2010 01:55:01 -0700, nils
wrote:

I want to swich between multiple sheets of active excel workbook with some
keyborad shortcuts.
We have Ctrl + Page Up/Page Down function to activate the desired sheet but
what i want is that it should give one pop-up showing all the sheet's name
and then i can choose any of them by using tab. Just like Alt + Tab to switch
beween the active programs of Windows.