Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread NOORAIN ANSARI
Dear Deba, Please see attached sheet, If you have any query, Please reply On Fri, Jun 8, 2012 at 7:37 PM, Deba Ranjan drdeva...@gmail.com wrote: Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread Deba Ranjan
Sir, The file you have attached is the same that i have attached. Please kindly check. Thanks for the same. Thanks Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:41 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Deba, Please see attached sheet, If you have any

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread NOORAIN ANSARI
Hi Deba, Please check cell no. E3 in Sheet1, It is working fine with me. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 8, 2012 at 7:43 PM, Deba Ranjan drdeva...@gmail.com wrote: Sir, The file you have attached is the same that i

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread Deba Ranjan
Thanks , It is possible for A2:A7 range including with E3, i mean for E3, its fine, It s possible for A2 to A7 also the same lock. Please sir, Explain in details how you did !!! Thanks Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:47 PM, NOORAIN ANSARI

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread NOORAIN ANSARI
Dear Deba, Please check below link.. http://www.lytebyte.com/2009/06/15/how-to-protect-only-certain-cells-columns-or-rows-in-excel/ On Fri, Jun 8, 2012 at 7:50 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks , It is possible for A2:A7 range including with E3, i mean for E3, its fine,

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread Deba Ranjan
Yes, Yes, its superb working thanks for the guides...Tnks Hilary Noorain and Rest of this members. Thanks Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 7:52 PM, hilary lomotey resp...@gmail.com wrote: select all the cells, press ctrl +1 go to the protection tab, uncheck

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread dguillett1
Unlock all you want to allow lock that one protect sheet Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Deba Ranjan Sent: Friday, June 08, 2012 9:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Edit Cell Dear Its is possible to Lock

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread Deba Ranjan
Ranjan drdeva...@gmail.com *Sent:* Friday, June 08, 2012 9:07 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Edit Cell Dear Its is possible to Lock a particular cell only, I mean user cant able to edit this cell only, rest they can able to edit. Even the E3 cell