2011 10:29 AM
To: excel-macros
Subject: $$Excel-Macros$$ Protect cells if it have data(re post)
Hi Experts,
I already posted this query, but i think my elaboration was not good.
Now I made the necessary changes in the sample file attached. pls check
it once more and tell me how to solve it.
Re
Hi Experts,
I already posted this query, but i think my elaboration was not good.
Now I made the necessary changes in the sample file attached. pls
check it once more and tell me how to solve it.
Regards
Rajesh Kainikkara
--
-
-macros
Subject: $$Excel-Macros$$ Protect cells if it have data
Hi Experts ,
Pls check the attached file .In it I have to protect the cells in
columns "C" to "AG" if it have any data, but the other columns for
entering name or serial number need not want to protect how can I solve
try this
Sub Macro1()
ActiveSheet.Unprotect Password:="ashish"
Cells.Select
Selection.Locked = False
Columns("C:AG").Locked = True
ActiveSheet.Protect Password:="ashish"
End Sub
On Tue, Jun 14, 2011 at 8:02 PM, Rajesh K R wrote:
> Hi Experts ,
>
> Pls check the attached file .In it
Hi Experts ,
Pls check the attached file .In it I have to protect the cells in
columns "C" to "AG" if it have any data, but the other columns for
entering name or serial number need not want to protect how can I
solve it.
Regards
Rajesh Kainikkara
--
---
