Page with tab names in cells
 

I have a rather large workbook. I would like to have a link to each tab on
the first tab (worksheet) in the workbook. What I envision is a cloumn of
cells with the sheet names in cells. When the cell or text is clicked on, the
user is taken to the corresponding worksheet.

Also, is there a way in VBA to get the tab names in order to populate the
cells?

Thanks

Page with tab names in cells
 

RW, have a look at BuildTOC here

http://www.mvps.org/dmcritchie/excel/buildtoc.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"RW" wrote in message
...
I have a rather large workbook. I would like to have a link to each tab on
the first tab (worksheet) in the workbook. What I envision is a cloumn of
cells with the sheet names in cells. When the cell or text is clicked on,
the
user is taken to the corresponding worksheet.

Also, is there a way in VBA to get the tab names in order to populate the
cells?

Thanks

Page with tab names in cells
 

RW,

You are talking about a Table of Contents.
The free Excel add-in "Excel Extras" will create one for you
with each sheet name hyperlinked to the sheet. It also provides
the number of printable pages.
The add-in can do other stuff like sort sheets and convert the case
of cell text. Download it here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"RW" wrote in message
I have a rather large workbook. I would like to have a link to each tab on
the first tab (worksheet) in the workbook. What I envision is a cloumn of
cells with the sheet names in cells. When the cell or text is clicked on, the
user is taken to the corresponding worksheet.

Also, is there a way in VBA to get the tab names in order to populate the
cells?

Thanks

Page with tab names in cells
 

Thanks Paul and Jim. I'll test these possibilities next week and let you know
if I have any questions.

"Jim Cone" wrote:

RW,

You are talking about a Table of Contents.
The free Excel add-in "Excel Extras" will create one for you
with each sheet name hyperlinked to the sheet. It also provides
the number of printable pages.
The add-in can do other stuff like sort sheets and convert the case
of cell text. Download it here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"RW" wrote in message
I have a rather large workbook. I would like to have a link to each tab on
the first tab (worksheet) in the workbook. What I envision is a cloumn of
cells with the sheet names in cells. When the cell or text is clicked on, the
user is taken to the corresponding worksheet.

Also, is there a way in VBA to get the tab names in order to populate the
cells?

Thanks