Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default alternative to hyperlinks

Hi Kevin,
You can have an alternative to hyperlinks, but since you appear
not to know that you can have hyperlinks (Excel 97 and up) why not
use a hyperlink.
See Build Table of Contents
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
and if you use hyperlinks you can use the BACK and FORWARD
buttons (alt+ArrowLeft and alt+ArrowRight) or toolbar buttons.

As far as alternatives you can have a macro that takes the
name in the active cell and goes to that sheet.
Perhaps the easiest of those alternatives is a double-click event macro
http://www.mvps.org/dmcritchie/excel....htm#gotosheet
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"kevin" wrote in message ...
I have a workbook with 30 plus tabs. is there a way to have a table of contents with each tab name where the user can click on a

name and be taken to the sheet.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! jacob735 Excel Discussion (Misc queries) 1 June 22nd 07 12:57 AM
Excel Hyperlinks- cell content v. hyperlinks herpetafauna Excel Discussion (Misc queries) 2 May 23rd 06 04:39 AM
alternative to hyperlinks No Name Excel Programming 0 May 12th 04 02:24 PM
alternative to hyperlinks Don Guillett[_4_] Excel Programming 0 May 12th 04 02:11 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"