nagavineela
09-20-2010, 02:18 AM
Hi,
I have a column A where the data is filled in with the combobox items.
It is nothing but names. I have 2 more columns with numbers.
How do we lock the column A without allowing user to delete using unprotect (as the sheet is protected) sametime user should be allowed to fill with text.
For Eg. Column A, Column B and Column C
Column A - Name, Column B - ID Num, Column C - Rank
User should not be allowed to edit Names but he can add names.
Column B and Column C - are allowed for editing.
Please help me.
Thanks,
I have a column A where the data is filled in with the combobox items.
It is nothing but names. I have 2 more columns with numbers.
How do we lock the column A without allowing user to delete using unprotect (as the sheet is protected) sametime user should be allowed to fill with text.
For Eg. Column A, Column B and Column C
Column A - Name, Column B - ID Num, Column C - Rank
User should not be allowed to edit Names but he can add names.
Column B and Column C - are allowed for editing.
Please help me.
Thanks,