View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RW RW is offline
external usenet poster
 
Posts: 49
Default 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