how do you make a summary page showing the workbook name with the excel sheet names

  • Thread starter Thread starter carole
  • Start date Start date
C

carole

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
 
Back
Top