Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create hyperlink cell in excel using VB
I have created a summary sheet from cells in other sheets. I have also
included the sheet name in a cell on each row of data in the summary (extract below). Does any one know how I can make the Cell with the sheet name a hyperlink to that sheet using Visual Basic? Greatful for any help! For Each sh In Worksheets If Left(sh.Name, 4) = "TEST" Then ' Only use those where the worksheet name starts with TEST Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Name CellLetterTo = CellLetterTo + 1 Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Range(TestDescription).Value CellLetterTo = CellLetterTo + 1 etc |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create hyperlink cell in excel using VB
With Worksheets("Summary")
.Cells(CellnumberTo, CellLetterTo).Value = sh.Name .Hyperlinks.Add anchor:=.Cells(CellnumberTo, CellLetterTo), Address:="", _ SubAddress:="'" & sh.Name & "'!A1" End With -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Haldane" wrote in message I have created a summary sheet from cells in other sheets. I have also included the sheet name in a cell on each row of data in the summary (extract below). Does any one know how I can make the Cell with the sheet name a hyperlink to that sheet using Visual Basic? Greatful for any help! For Each sh In Worksheets If Left(sh.Name, 4) = "TEST" Then ' Only use those where the worksheet name starts with TEST Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Name CellLetterTo = CellLetterTo + 1 Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Range(TestDescription).Value CellLetterTo = CellLetterTo + 1 etc |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
create hyperlink cell in excel using VB
Something like this:
Sub Hyp_Add() Dim sh As Worksheet Dim CellnumberTo As Long Dim CellLetterTo As Integer For Each sh In Worksheets If Left(sh.Name, 4) = "TEST" Then ' Only use those where the worksheet 'name starts with TEST Worksheets("Summary").Hyperlinks.Add Anchor:= _ Cells(CellnumberTo, CellLetterTo), Address:="", _ SubAddress:=sh.Name & "!A1", _ TextToDisplay:=sh.Name CellLetterTo = CellLetterTo + 1 Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = _ sh.Range(TestDescription).Value CellLetterTo = CellLetterTo + 1 'etc End If Next End Sub Mike F "Haldane" wrote in message ... I have created a summary sheet from cells in other sheets. I have also included the sheet name in a cell on each row of data in the summary (extract below). Does any one know how I can make the Cell with the sheet name a hyperlink to that sheet using Visual Basic? Greatful for any help! For Each sh In Worksheets If Left(sh.Name, 4) = "TEST" Then ' Only use those where the worksheet name starts with TEST Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Name CellLetterTo = CellLetterTo + 1 Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Range(TestDescription).Value CellLetterTo = CellLetterTo + 1 etc |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
create hyperlink cell in excel using VB
Thanks Jim that worked first time -
"Jim Cone" wrote: With Worksheets("Summary") .Cells(CellnumberTo, CellLetterTo).Value = sh.Name .Hyperlinks.Add anchor:=.Cells(CellnumberTo, CellLetterTo), Address:="", _ SubAddress:="'" & sh.Name & "'!A1" End With -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Haldane" wrote in message I have created a summary sheet from cells in other sheets. I have also included the sheet name in a cell on each row of data in the summary (extract below). Does any one know how I can make the Cell with the sheet name a hyperlink to that sheet using Visual Basic? Greatful for any help! For Each sh In Worksheets If Left(sh.Name, 4) = "TEST" Then ' Only use those where the worksheet name starts with TEST Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Name CellLetterTo = CellLetterTo + 1 Worksheets("Summary").Cells(CellnumberTo, CellLetterTo) = sh.Range(TestDescription).Value CellLetterTo = CellLetterTo + 1 etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create HTML code for a hyperlink from cell contents | Excel Worksheet Functions | |||
Create an hyperlink automatically in a cell | Excel Discussion (Misc queries) | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Create a hyperlink with querystring from cell | Excel Programming | |||
How to create a hyperlink in excel, using the text in a cell. | Excel Worksheet Functions |