How to Prevent the Deletion of Hidden Cells after Enabling Sort Functions

xAmyyyyyx

New Member
Joined
Nov 22, 2018
Messages
1
Hello,

I have followed the process of locking my worksheet then enabling the relevant columns to Sort using the 'Allow Edit Ranges' function. I unchecked the 'Select Locked Cells' option when protecting the worksheet so nobody can select the cells and edit them. However when I hide the relevant columns, the data can still be deleted if you highlight the entire row and 'delete'. Is there a way I can prevent this from happening?

-Amy-
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Hi Amy,


I opened a new workbook with 1 sheet and unlocked all the cells. Then I put '555' into cell i17 and locked cell i17. Then I protected the sheet and checked every single box (allowing all permissions) EXCEPT for 'delete rows' and 'delete columns' ...now, whether i17 is in a hidden row/column or not, I cannot seem to delete the contents - not by selecting one or more rows or columns and pushing the delete key nor right-click and delete. If this works the same for you, perhaps you can add the permissions you want as long as those two boxes are not included.


Tai
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

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
Back
Top