Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-21 Thread Rakesh Sharma
* Thanks sir,,, but i wanna sum for the same .. formula which is sent u 1stly its not working proprly so can u send it in 2nd sheet .. plz do the needful. * On Tue, Dec 21, 2010 at 3:40 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > you can use Sumproduct for same output... > Please see attach

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-21 Thread Rakesh Sharma
* Dear Sir, Plz if any other formula... plz * On Tue, Dec 21, 2010 at 12:46 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > Please see attached sheet.. > > Thanks, > Noorain Ansari > > On Mon, Dec 20, 2010 at 11:02 PM, Rakesh Sharma > wrote: > >> * >> HI, >> >> >> help required as mention

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-20 Thread C.G.Kumar
older when Excel is launched) > Paul > > > *From:* C.G.Kumar > *To:* richard.m...@gmail.com > *Cc:* excel-macros@googlegroups.com > *Sent:* Mon, December 20, 2010 12:09:29 AM > *Subject:* Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened > > I have used the

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-20 Thread Paul Schreiner
the file in the XLStart folder (Excel opens all files in this folder when Excel is launched) Paul > >From: C.G.Kumar >To: richard.m...@gmail.com >Cc: excel-macros@googlegroups.com >Sent: Mon, December 20, 2010 12:09:29 AM >Subject: Re: $$Excel-Macros$$ Re: Run a macro every time e

Re: $$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-19 Thread C.G.Kumar
I have used the following code; Sub Workbook_Open() Application.DisplayAlerts = False On Error Resume Next Workbooks.Open Filename:= _ "E:\Documents and Settings\DRIVE\Desktop\Tasks.xls On Error GoTo 0 Application.DisplayAlerts = True End Sub I have made macro security to low & i

$$Excel-Macros$$ Re: Run a macro every time excel is opened

2010-12-18 Thread Richard
Create a sub called "sub workbook_open" in "this workbook" and call your macro. On Dec 18, 3:34 am, "C.G.Kumar" wrote: > I want a macro to run every time when an excel file is opened. -- -- Some important links for