Drop-down box always visible in a workbook

[HBj]

Hi gurus,

I have a workbook containing more than 10 sheets.

Because it is annoying scrolling/changing the sheets, I would like to do a
drop-down list of all sheets by which I could more easily change the active
sheet. How can I make this drop-down visible like a customized toolbar?
(Working with Office 2000/2003)
Håkan

--

 

[Peter T]

Right click over the four arrows at the bottom left corner of the sheet, to
left of the first sheet tab.

Regards,
Peter T

 

[The Code Cage Team]

Hi,

You can right-Click the sheet navigation controls in the lower left
and you have a worksheet popup list.

However, it can be done using vba if you really wanted, but Excels ow
built in functionality is far better

--
The Code Cage Tea

Regards,
The Code Cage Team
www.thecodecage.co

 

[Debra Dalgleish]

Dave Peterson has a sample file and instructions for creating a toolbar
drop down with a list of worksheets:

http://www.contextures.com/xlToolbar01.html