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

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

WildWill wrote:

Hi

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