protect rows and columns from deleting

[RAJESH1960]

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.

 

[RAJESH1960]

:{

 

[Fluff]

You can protect the Workbook, which will prevent users from renaming the sheets.

 

[RAJESH1960]

H

You can protect the Workbook, which will prevent users from renaming the sheets.

Will they be able to use the worksheet, I mean enter data in the unprotected cells. How do I protect the workbook...??

 

[Fluff]

Will they be able to use the worksheet

Yes

How do I protect the workbook

The button next to Protect Sheet on the ribbon.

 

[RAJESH1960]

You can protect the Workbook, which will prevent users from renaming the sheets.

Got it Fluff. Thanks

 

[Fluff]

You're welcome & thanks for the feedback.