Deleting rows in a protected sheet

[sapper]

This might be a silly question, but is there a way to delete a row in a protected sheet for someone who is using the sheet without the password? I can't find anything online.

Any help would be appreciated.

 

[Joe4]

You could create VBA code that would temporarily unprotect the sheet, delete the row, and re-protect the sheet.
The VBA code would have the password in it, so you would need to be sure to hide the VBA code (so they can run it, but not view it).

 

[sapper]

Unfortunately I don't know how to use VBA code. The issue is I have an excel matrix with formulas that I have locked and hidden. I want others to be able to update and delete rows that are no longer needed. I am just not sure how to protect the formulas without password protecting the entire worksheet.

 

[Joe4]

I don't know of a way that you can. I think that any solution will probably require VBA.
See here: https://www.mrexcel.com/forum/excel-questions/374666-vba-allow-user-delete-locked-cell.html

 

[sapper]

Thank you. I will have to figure out how to use VBA and this may just work. Thanks for the assistance.

 

[Joe4]

There really shouldn't be much to it. Just copy and paste that VBA code from the other link to a new VBA module in your workbook (adjusting your password).
Then just place your cursor on the row you want to delete, and run the macro.
See here for instructions on how to do those things: https://www.ablebits.com/office-addins-blog/2013/12/06/add-run-vba-macro-excel/

You can also run the VBA code from buttons on keyboard shortcuts, if you want to do that.

See here for how to hide your VBA code: https://stackoverflow.com/questions/9425461/how-to-hide-code-in-vba-applications

 

[sapper]

Thank you for all your help. I really appreciate it.

 

[Joe4]

You are welcome!
Glad I was able to help.