Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
alternative to hyperlinks
-----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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
alternative to hyperlinks | Excel Programming |