go to the right worksheet

[Guest]

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

 

[Gord Dibben]

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/micr...464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25


Gord Dibben MS Excel MVP

 

[Guest]

Wow!! I am somewhat embarrassed to admit, but I have spent a good portion of
the last two days looking for just this!!

Thank you so much for posting the links to both methods.

I needed the Worksheet Navigation bar for a template I've been coding, which
can have very easily have 20 worksheets, and sometimes as many as 60. Being
that I hope to deploy this to a lot of users, is there any way to incorporate
the Add-in directly to the template code that's in modules, and then call the
creation of the toolbar from either an event or a predictable macro?

I think that if it were possible, the deployment of the template would be
much simpler for me & for the users (unless I were to build a setup script
which installed both the add-in and the template... yeah, I'd rather not go
down that road at all!)

thanks again, this group has helped tons,

from sweltering San Diego,

 

[Dave Peterson]

Personally, I wouldn't put the code in a specific workbook. You may find that
you end up with multiple workbooks with the same code and bad things happen when
you open both those workbooks at the same time (or close one of them).

In fact, I think that if you think the utility is useful, it could be useful for
other workbooks, too--maybe not workbooks that you've designed.

I'd put the utility in a common network location and instruct people how to use:
tools|addins|browse to that network location and install.

(or just send out a copy to each person who doesn't have the network available
all the time and let them install it.)

Then it'll be available as long as the user wants it available.

========
But if you want, you could just put all that code in a general module of your
workbook. And you should be set. (I still wouldn't do it, though.)