How to protect some rows and other rows are non protect and able to delete rows

I have one issue, i want to protect the sheet, but delete permission will be given to the user. But upto 9 rows are hidden, these rows should not be deleted. Is there any possibility. Please help me.

Thanks in advance for any help.


Try this. I just tested this and it seems to get at what you want.

  • Unlock cells in all rows that will not be hidden.
  • Keep all rows that are to be hidden locked
  • Hide the rows
  • Protect the worksheet with the following priviliges: Select Unlocked cells Delete Rows (whatever else you wish to give them)

In this way, a user will not be able to select the hidden rows because they are locked. However, if a user wants to delete rows above / below the hidden ones, they will have to use Ctrl + Mouse Click to select the separate ranges.

Also, with this solution. You don't even need VBA. You just have to set it up before you protect the sheet, than add the protection.

Need Your Help

C++ crash Segmentation fault: 11

c++ crash segmentation-fault runtime-error

I have been working on a program to test out a few string manipulation possibilities. It is basically supposed to read a string list and be able to find a character's neighbors to go through the st...

Oracle REGEXP_LIKE to perform (case,space,special..etc)-insensitive column match with a search string

sql regex oracle special-characters

I have a search keyword that I am looking in a column of my table. My search query string may contain special characters like $.