RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-31 Thread Daniel
31, 2011 at 1:57 PM Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules To: excel-macros@googlegroups.com It will be very difficult to move the code to the personal.xlsb workbook without the initial file retaining some code. Can you explain why you want to do so ? Maybe there should be a

RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-31 Thread Daniel
> Target.ShowDetail = True > > ActiveSheet.Name = Target.Offset(, -1).Value > > End If > > End Sub -- Forwarded message ------ From: Daniel Date: Sun, Jul 31, 2011 at 12:53 AM Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules To:

RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-30 Thread Daniel
À : excel macro forum Objet : Re: $$Excel-Macros$$ Help needed to comine VBA modules Dear daniel, Thanks. Now it is working fine.But the sub 'Worksheet_BeforeDoubleClick' is included as worksheet level event routine of w.sheet analysis.How can i incorporat

Re: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-30 Thread aju chacko
> > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Daniel > Sent: Saturday, July 30, 2011 6:12 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Help needed to comine VBA mo

Re: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-30 Thread aju chacko
macros@googlegroups.com] > On Behalf Of Daniel > Sent: Saturday, July 30, 2011 6:12 PM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Help needed to comine VBA modules > > Here is my test file. > > -Message d'origine- > De : excel-macros@goog

RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-29 Thread Daniel
… each tim you double click on a value of the pivot, the worksheet will be created with the desired name. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 16:25 À : excel macro forum Objet : Fwd: $$Ex

RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-29 Thread Daniel
Paste the macro below in the ANALYSIS module : Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim rg As Range Set rg = Sheets("ANALYSIS").PivotTables(1).DataBodyRange If Intersect(Target, rg) Is Nothing Then Exit Sub Cancel = True If T

RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-29 Thread Daniel
HI, Can you explain a bit more ? Thanks. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : vendredi 29 juillet 2011 00:37 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Help needed to comine VBA

Re: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-28 Thread aju chacko
Thank u very much Daniel,can u help me in naming the sheets created while pivot table being drill down aju On Thu, Jul 28, 2011 at 2:46 PM, Daniel wrote: > Hi, > > You should indicate the file name before the function : > Eg. Personal.xlsb! SpellNumber... > > Regards. >

RE: $$Excel-Macros$$ Help needed to comine VBA modules

2011-07-28 Thread Daniel
Hi, You should indicate the file name before the function : Eg. Personal.xlsb! SpellNumber... Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de aju chacko Envoyé : jeudi 28 juillet 2011 06:10 À : excel-macros@googl