Dynamic Hyperlink between Summary and
Detail sheet
To: excel-macros@googlegroups.com
Date: Monday, May 6, 2013, 9:01 PM
Hi all,
I have a requirement to create a hyper link between two sheets (Summary
and detail) in the attached sheet.
I need to create a hyperlink in summary sheet, for all
Hi all,
I have a requirement to create a hyper link between two sheets (Summary and
detail) in the attached sheet.
I need to create a hyperlink in summary sheet, for all the value cells from
B2:E5.
From the created 16 hyperlinks from summary sheet, if for example , I click
on cell B2, the
try this see if it helps
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Dim wk As Worksheet
Set wk = Sheets(Detail)
Application.EnableEvents = False
On Error GoTo Err:
If Target.Count = 1 And Not Intersect(Target, Range(b2:e5)) Is
Nothing
Thanks Ashish for your lightening response !!!.
This meets exactly, what I expected !!!.
Thanks.
Eugene
On Mon, May 6, 2013 at 9:57 PM, ashish koul koul.ash...@gmail.com wrote:
try this see if it helps
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
