Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-22 Thread kvc praveen kumar
Hi Vinod, I was expecting the same output as Harmeet does. Can you send us an example file with the problem and the output you require in case the above doesnt help you. On Wed, Dec 23, 2009 at 8:27 AM, Harmeet Singh wrote: > Hi Vinod, > > Attaching a sample file. > If this is what u want, u migh

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-22 Thread Harmeet Singh
Hi Vinod, Attaching a sample file. If this is what u want, u might wanna read my previous reply again else team would surely help u. Thanks & Regards, Harmeet Singh Sent via BlackBerry Wireless On Wed, Dec 23, 2009 at 2:53 AM, Vinod N wrote: > Hi Harmeet and Praveen, > > Thanks for the your

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-22 Thread Vinod N
Hi Harmeet and Praveen, Thanks for the your kind reply.. However, as i mentioned in my mail, the excel will be shared among many folks, who will be updating it simultaneously... As of now, I have already locked the formulas as mentioned by Praveen... This solution is available in one of the Excel

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-20 Thread Harmeet Singh
to protect selected cells , follow mention steps: 1. Select all cells. 2. goto format cells>protection then uncheck locked button. 3. Select cells which u wanna protect.goto format cells>protection then uncheck locked button. 4. goto format cells>protection then check locked button

Re: $$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-20 Thread kvc praveen kumar
*Hi,* *Please go through the below article. It will help you on how to unprotect only few cells using three different ways. * *Let me know if you find any issues.* *Regards,* *Excel King* The easiest and most common way of barring people from playing with your formulas is to protect your works

$$Excel-Macros$$ Locking/Freezing a range of cells

2009-12-20 Thread Vinod N
Hi Excel Gurus, I have an shared excel file saved in the shared folder... I want to allow users to use from Range A21:K3020. I tried protecting the worksheet but there are many limitation. Is there other way of locking other that protect worksheet... Please help... -- Thanks and Regards Vinod