Deleting Rows form Protected Sheet




I have a worksheet whihc has a combination of protected and unprotected
columns of data. I want to enable users to delete rows even when the
worksheet is protected, and I have selected "Edit Objects" and "Edit
Scenario's (amongst other options) in the Protect Sheet window, yet when I
want to delete rows form the worksheet I get a message saying that some of my
cells are protected and I firts need to unprotect them before I can delete
rows. Is there a way around this?



Dave Peterson

How about unlocking all the cells in each of the rows that should be able to be

If you can't do that, you could provide a macro that unprotects the worksheet,
does the delete, and then reprotects the worksheet.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question