RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello Everyone,
I have created this app in excel where I have used formulas and codes. Except for the cells where the data is to be entered, the whole sheet is protected. The sheet will work only if the data is entered manually or copied and pasted in the unprotected cells. If a new data is to be entered, you will need to clear the old data in the cells by using the delete button. I want a way to avoid the user to delete any entire row or column. If the user deletes, then the application will not generate the required result. Is there a way I can protect the rows and columns from being deleted.? Also, the user should not be able to insert any additional row or column in the sheet. The name of the sheet is also included in the code. I need to protect the name of the sheet too.
I have created this app in excel where I have used formulas and codes. Except for the cells where the data is to be entered, the whole sheet is protected. The sheet will work only if the data is entered manually or copied and pasted in the unprotected cells. If a new data is to be entered, you will need to clear the old data in the cells by using the delete button. I want a way to avoid the user to delete any entire row or column. If the user deletes, then the application will not generate the required result. Is there a way I can protect the rows and columns from being deleted.? Also, the user should not be able to insert any additional row or column in the sheet. The name of the sheet is also included in the code. I need to protect the name of the sheet too.
Last edited: