tab list menu pop up anywhere

Hi,

I am using Excel 2003 (also have 2007 on some pcs).

I recently found that if you right click on the bottom left tab arrows, all the tabbed worksheets pop up as a list.

I have a hyperlink on each of my worksheets which goes to my own MENU (tab1), cell A1. From there I have a quick link of all the tabs to chose from (more than 20). Is it possible to make a button displayed somewhere on my worksheet (or on the top menu) with the same operation as 'right click on the arrow'? That is to display all the tabs in a list.

'right click' in the bottom left (above 'ready') opens the full tab list. Is it possible to have that same operation in an excel sheet, when you click on a cell (with text 'TAB' in it for example) the full tab list opens up so you can easily switch to another tab of your choice?

Thanks for any ideas.
Andy

Originally Posted by :) Sixthsense :)

Try this addin

Thanks for the idea. You should give more info about the addin, as blindly downloading an excel file, disabling macros and then finding where the add-in is extracted, is a bit risky.

Needless to say, it was safe. But that addin is more time consuming that clicking through to my existing menu. And certainly more time consuming than using right-click on the tab arrows.

Thanks for the idea though.
Andy