Deleting Rows form Protected Sheet
 

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?

Deleting Rows form Protected Sheet
 

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