go to the right worksheet
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
|