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 E3 cell
 should not be able to edit, Rest can be edit. Please see the attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of EDIT CELL(Deba).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


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 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 E3 cell
 should not be able to edit, Rest can be edit. Please see the attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com




  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

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 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 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 E3
 cell should not be able to edit, Rest can be edit. Please see the attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com








  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Copy of EDIT CELL(Deba).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


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 noorain.ans...@gmail.comwrote:

 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 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 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 E3
 cell should not be able to edit, Rest can be edit. Please see the attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com








  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com




  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 

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, 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 
 noorain.ans...@gmail.comwrote:

 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 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.com
  wrote:

 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.comwrote:

 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 should not be able to edit, Rest can be edit. Please see the 
 attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com








  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com




  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : 

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 the
 lock button, click ok, and then select the cell you want to lock and click
 on ctrl +1 go to protection tab and check lock. click ok, go to review
 ribbon and click on protect , ok, you shd be fine


 On Fri, Jun 8, 2012 at 2:17 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.comwrote:

 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 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.com
  wrote:

 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.comwrote:

 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 should not be able to edit, Rest can be edit. Please see the 
 attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com








  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com




 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com




  --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive 

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 a particular cell only, I mean user cant able 
to edit this cell only, rest they can able to edit. Even the E3 cell should not 
be able to edit, Rest can be edit. Please see the attached. thank you.
   


Thanks  Regards,
Deba Ranjan P





-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com
 
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ Edit Cell

2012-06-08 Thread Deba Ranjan
Thanks Lovely members.


Thanks  Regards,
*Deba Ranjan P*





On Fri, Jun 8, 2012 at 8:01 PM, dguillett1 dguille...@gmail.com wrote:

   Unlock all you want to allow
 lock that one
 protect sheet

 Don Guillett
 Microsoft MVP Excel
 SalesAid Software
 dguille...@gmail.com

  *From:* Deba 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
 should not be able to edit, Rest can be edit. Please see the attached.
 thank you.


 Thanks  Regards,
 *Deba Ranjan P*


 
 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com

 --
 FORUM RULES (986+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com


-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com