-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
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
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$$ Lock
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 titles
