$$Excel-Macros$$ Locking Only Selected Cell

Dear Experts, Can someone please let me know how to lock only selected cell? Thanks, Sharad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Locking Only Selected Cell

Unlock ALL cells and use a worksheet_selectionchange event to lock itthen protect sheet Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: sharad jain Sent: Friday, September 14, 2012 6:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Locking

Re: $$Excel-Macros$$ Locking Only Selected Cell

Hi, Select sheet(Ctrl+A)--Goto Format cells--untick*Locked*--Ctrl+Click desire cell--Goto Format cells--tick*Locked*--ok--click*protect sheet*. Now desire cell only lock. Thanks karthik On 14 September 2012 17:07, sharad jain jainshar...@gmail.com wrote: Dear Experts, Can someone please let

RE: $$Excel-Macros$$ Locking Only Selected Cell

-macros@googlegroups.com] On Behalf Of karthikeyan sankaran Sent: 14 September 2012 5:59 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Locking Only Selected Cell Hi, Select sheet(Ctrl+A)--Goto Format cells--untick*Locked*--Ctrl+Click desire cell--Goto Format cells--tick*Locked*--ok