vkarthik21
New Member
- Joined
- Sep 25, 2014
- Messages
- 1
In my excel worksheet there is a table containing 5 columns say Column A- Column E. I want to do apply following restrictions to it -
1. User should not be able to edit one column i.e. Column A and the rest of the columns he can input the data.
2. User should not be able to delete or insert new row but should be able to enter the data.
3. For a particular row, Column B and Column E are mandatory and the user should be thrown an error if the excel is saved or before moving to the next entry.
Could someone help me on what are the best ways to go about enabling such restrictions? Online help is not very helpful currently as protect worksheet is the only thing that I am gettting redirected to which is pretty confusing and its a all or none approach.
Thanks,
Karthik
1. User should not be able to edit one column i.e. Column A and the rest of the columns he can input the data.
2. User should not be able to delete or insert new row but should be able to enter the data.
3. For a particular row, Column B and Column E are mandatory and the user should be thrown an error if the excel is saved or before moving to the next entry.
Could someone help me on what are the best ways to go about enabling such restrictions? Online help is not very helpful currently as protect worksheet is the only thing that I am gettting redirected to which is pretty confusing and its a all or none approach.
Thanks,
Karthik