$$Excel-Macros$$ Protect shared workbook

2014-07-23 Thread Suman
Hi, I have created a macro on *Change event* to protect a particular column (Column A) when the user put anything in any cell of that column. Now the thing is that code is working properly in normal mode but its not working when I share this workbook. Please help to resolve my query. *Suman

Re: $$Excel-Macros$$ Protect shared workbook

2014-07-23 Thread Vaibhav Joshi
Pl refer: office.microsoft.com/en-us/excel-help/features-that-are-unavailable-in-shared-workbooks-HP005201080.aspx Cheers!! On Wed, Jul 23, 2014 at 2:38 PM, Suman ksuman1...@gmail.com wrote: Hi, I have created a macro on *Change event* to protect a particular column (Column A) when the

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, Please suggest what kind of more features are adding to do it more attractive, innovative useful. Kindly suggest. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: cheers!! Working on adding more features viz. managing attachments etc..will share

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, Added BCC funciton is possible in it. Please help. Thanks Regards Ashu Kenith On 7/23/14, Vaibhav Joshi v...@vabs.in wrote: cheers!! Working on adding more features viz. managing attachments etc..will share once done, you can recommend additional features if you want

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, If possible than please add BCC function, Text font function, Text colour function, Bold Italic, Underline etc. If these function are adding in it then it's looks more interactive and useful. Kindly help. Thanks Regards Ashu Kenith On 7/23/14, Ashu k direct2as...@gmail.com

$$Excel-Macros$$ Re: Indirect Function Not Working on Dates Please Help

2014-07-23 Thread Haseeb Avarakkan
Hello Dileep, In Summary!B5 =SUMIF(INDIRECT(TEXT($A5,'dd-mm-')!C:C),B$3,INDIRECT(TEXT($A5,'dd-mm-')!F:F)) Then copy down other Amount columns. Haseeb On Mon, Jul 21, 2014 at 2:42 PM, Dileep Kumar deepuk...@gmail.com wrote: Dear Friends, Please find attached Daily Reporting

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashish Kumar
Hi Vaibhav, Reformatted version is great. Regards Ashish On 23 July 2014 11:32, Vaibhav Joshi v...@vabs.in wrote: PFA Reformatted !! Cheers!! On Wed, Jul 23, 2014 at 7:33 AM, Ashu k direct2as...@gmail.com wrote: Dear Vaibhav Sir, I am facing 2 problems know. First is - when I am