Deleting Rows form Protected Sheet

W

WildWill

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?
 
D

Dave Peterson

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.
 

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

Similar Threads

Delete rows while sheet protected 3
hide, unhide column or row after protect worksheet 4
protect unprotect toggle VBA 6
Allow Insert Rows in a protected worksheet 2
Delete Rows in a protected worksheet 2
Sheet Protection 3
delete rows 1
Protect cells but allow for user input. 3

Top