alternative to hyperlinks

G

Guest

-----Original 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.
.
Hyperlinks work great for that application. You can
insert them with code. This explanation is from the Excel
HELP. In HELP type HYPERTEXT check out the add method:
Adds a hyperink to the specified range or shape. Returns
a Hyperlink object.

Syntax

object.Add(Anchor, Address, SubAddress, ScreenTip,
TextToDisplay)

object Required. An expression that returns a Hyperlinks
object.

Anchor Required Object. The anchor for the hyperlink.
Can be either a Range or Shape object.

Address Required String. The address of the hyperlink.

SubAddress Optional Variant. The subaddress of the
hyperlink.

ScreenTip Optional Variant. The screen tip to be
displayed when the mouse pointer is paused over the
hyperlink.

TextToDisplay Optional Variant. The text to be displayed
for the hyperlink.

*****
working in the same workbook leave address blank but fill
in detail for subaddress. I used this in a loop and it
does the trick
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="",
SubAddress:= "SHEETNAME!A1", TextToDisplay:="ANY TEXT"

Regards,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top