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

2012-09-14 Thread Rajan_Verma
-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

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

2012-09-14 Thread karthikeyan sankaran
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 wrote: > Dear Experts, > > Can someone please let me know how to loc

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

2012-09-14 Thread dguillett1
Unlock ALL cells and use a worksheet_selectionchange event to lock it>then 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