Is it possible to link pages in two separate workbooks

[taytools]

Does anyone know if it is possible to link pages in multiple workbooks. I want to be able to click on a upc code in a cell and have it take me to the same upc code in a separate workbook. Does anyone know how to do this? Basically you would have to search by the upc code. I have done this in in different pages of an excel workbook, but never in two separate workbooks.

I have provided the code I used below. If anyone knows a way to modify it to work for two separate workbooks please let me know. Thanks!

Option Explicit

Public Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim Found As Range

Set Found = Worksheets("Sheet1").Cells.Find(what:=Target.Value, LookIn:=xlValues, lookat:=xlWhole)
If Found Is Nothing Then
Cancel = True
Else
Cancel = False
Worksheets("Sheet1").Activate
Found.Select
End If

End Sub

 

[taytools]

Also I have tried this with and without using option explicit at the very beginning. Not sure if that helps. Thanks!

 

[AFPathfinder]

If it's highlighting this line,

[COLOR=#333333]Public Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)[/COLOR]

keep hitting F8 and see if another box pops up with a runtime error. I'm curious which part of the syntax it thinks is a variable.

 

[taytools]

F8 does not search for errors on my computer. I did not know it was even possible to do this. My email is clayton.cary@taytools.com. Would it be possible for you to email me so I could send you the two excel files?