Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel hyperlink problems
Hi Peter,
What are you hyperlinking to ? - cell in another worksheet - cell in another workbook worksheet - web page What do you mean by don't take up the desired value ? Do you mean they are not displaying the value of they hyperlinked to cell ? What do you mean by the old ones ? Different version of Excel ? Not created by your program code ? I have some programmed hyperlink examples in http://www.mvps.org/dmcritchie/excel/buildtoc.htm The following converts a range of cells with sheetnames to hyperlinks. Sub trevor001() Dim Cell As Range For Each Cell In Selection ActiveSheet.Hyperlinks.Add Anchor:=Cells(Cell.Row, Cell.Column), _ Address:="", SubAddress:="'" & Sheets(Cell.Value).Name & "'!A1" Next Cell End Sub Without a snippet of code it's hard to tell what you have in code, along with what you get and what you want. If I create a hyperlink with Right-Click, the hyperlink will point to the wrong place after inserting or deleting rows. The example of using Hyperlink Worksheet Function gets around that problem and gets around having to code the pathname in Excel 97 and 2000 even when on the same workbook and same worksheet. Some examples of the HYPERLINK Worksheet Function http://www.mvps.org/dmcritchie/excel....htm#hyperlink =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) Perfectly transparent to insertion/deletion of rows/columns will still point to the correct place (unless you delete the target). --- 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 "Peter" wrote in message ... Hi I have two problems with Excel. 1 I can't seem to create any new hyperlinks (I don't know if this is how you call it in English, I have a hungarian version). The hyperlinks I try to create point to the right place but don't take up the desired value. The old ones work fine though. 2 How can I create a hyperlink to another excel workbook's specified cell? Thanks very much in advance, Peter Baranya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink problems | Excel Worksheet Functions | |||
Excel hyperlink problems | Excel Discussion (Misc queries) | |||
hyperlink problems with multiple sheet spreadsheet on Intranet | Excel Discussion (Misc queries) | |||
Problems with HYPERLINK in Excel 2002 and 2003 | Excel Worksheet Functions | |||
Hyperlink Problems | Excel Worksheet Functions |