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.
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.
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" <[email protected]> a écrit dans
le message de news: [email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks