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
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
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
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
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,
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
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
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