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

Deleting files & folders 0
Allowing Delete Table Rows at a Cells Protected Worksheet 0
Delete rows while sheet protected 3
Allow Insert Rows in a protected worksheet 2
Code to format cells on several worksheets 2
Protected Worksheet Tab Order 1
protect unprotect toggle VBA 6
Move direction problem when protected 0

Top