Barb

How about a navigation bar from Debra Dalglesih?

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

Or Bob Phillips' Browsesheets macro?

See this google search result.

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


Gord Dibben MS Excel MVP

On Tue, 14 Aug 2007 16:44:00 -0700, Barb wrote:

I have a class that is creating worksheets like
worksheetA1
worksheetA2
.
.
.
.
I want to keep each name in a column like A1 to A100
each time I open the workbook, it populates a listbox.
Is it possible to send all these worksheet name in a list box and when I
double click on one of the names it sends me directly to the right sheet???

thanks