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.

hi Nils

You can just right click on the rightmost arrow before first tab, and
that will give you a list of all sheets in the workbook to choose from.
--
Regards
Roger Govier

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.

Assume that you are in sheet1 and you would like to go to sheet3 press
Cntrl+G which will open goto dialog box and in Reference type Sheet3!A1 and
hit enter. Now the Active sheet will be sheet3. Like that In Goto Reference
type your sheet name with cell reference to move quickly between the sheets.
--
Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


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

Besides you may try to use "workbook navigation" Excel addins from below
site. It has many options to swich from one sheet to other sheet.


http://shahshaileshs.web.officelive.com/Addins.aspx


Regards,
Shailesh Shah
http://shahshaileshs.web.officelive.com/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://shahshaileshs.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
http://shahshaileshs.web.officelive....ssic_Menu.aspx



"nils" wrote in message
...
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.

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.