CODEWITHSUNDEEP
excelvbahyperlink
Dullspark
Dullspark

Reputation: 215

Create a Hyperlink that links to another worksheet

I'm trying to create a hyperlink in a sheet called "Summary-Champion Specific" that links to a sheet called "Hidden Sheet". I've tried using the following code where P1 and P and iterative numbers however cannot get it to work.

 Sheets("c").Hyperlinks.Add Anchor:=Sheets("c").Range(Cells(P1, P), Cells(P1, P)), Address:="", SubAddress:=Sheets("Hidden Sheet").Range(Cells(P1, P), Cells(P1, P)).Address(External:=True)

Any Ideas?

Upvotes: 0

Views: 57

Answers (1)

DisplayName
DisplayName

Reputation: 13386

try

Sheets("Summary-Champion Specific").Hyperlinks.Add Anchor:=Sheets("Summary-Champion Specific").Cells(p1, p), Address:="", SubAddress:=Sheets("Hidden Sheet").Cells(p1, p).Address(External:=True)

in any case, should "Hidden Sheet" worksheet be hidden, the link wouldn't bring you anywhere

Upvotes: 1

Related Questions