protect rows and columns from deleting

RAJESH1960

Active Member
Joined
Mar 26, 2020
Messages
482
Office Version
  1. 2019
Platform
  1. 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.
 
Last edited:

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,969
Office Version
  1. 365
Platform
  1. Windows
You can protect the Workbook, which will prevent users from renaming the sheets.
 
Solution

RAJESH1960

Active Member
Joined
Mar 26, 2020
Messages
482
Office Version
  1. 2019
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,969
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,309
Messages
5,641,448
Members
417,209
Latest member
Agbarker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top