How do you make a summary page which would have the bookbook name as the
folder and the excel sheets listed under, so that when you look up your
file you get the folder (workbook name) and then the sheets are under
and you can click on any to open.


--
carole
------------------------------------------------------------------------
carole's Profile: http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=544354

I have home-made XLA that should help: http://cjoint.com/?fwqZQdNgus
It is not protected: you can view & edit the code and the userform

To have tabs alpha ordered, right click on arrows left of tabs list, and
select "Sort tabs"

To select a sheet:
Right-click on a cell and select "Select sheet"
You can type the beginning of the name: it will select corresponding entry
of the list.
To validate: press Enter or double-click on a name
To cancel: press Escape

HTH
--
AP

"carole" a écrit dans
le message de news: ...

How do you make a summary page which would have the bookbook name as the
folder and the excel sheets listed under, so that when you look up your
file you get the folder (workbook name) and then the sheets are under
and you can click on any to open.


--
carole
------------------------------------------------------------------------
carole's Profile:
http://www.excelforum.com/member.php...o&userid=34643
View this thread: http://www.excelforum.com/showthread...hreadid=544354