Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-10 Thread Eugene Bernard
Hi Ravindar Thank you. Regards Eugene On Tue, May 7, 2013 at 12:46 PM, ravinder negi wrote: > Hi, PFA solved. > > --- On *Mon, 5/6/13, Eugene Bernard * wrote: > > > From: Eugene Bernard > Subject: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and >

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-06 Thread Eugene Bernard
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 wrote: > try this see if it helps > > Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As > Boolean) > > Dim wk As Work

Re: $$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-06 Thread ashish koul
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 Nothi

$$Excel-Macros$$ Creating Dynamic Hyperlink between Summary and Detail sheet

2013-05-06 Thread Eugene Bernard
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 detai