How do I delete rows from a protected worksheet?
 

I'm trying to provide a spreadsheet to my sales reps that needs to be
protected from editing information like price, descriptions etc.. In turn,
these sales reps need the ability to remove sections to tailor the list for
each of their customers by deleting certain rows. How can I accomplish this?

Lock the cells you don't want them messing with and make sure you unlock
ALL other cells (all cells by default are already locked).

Protect the sheet and under the sections "Allow all user of this worksheet
to", make sure you uncheck "Select locked cells"

HTH

The cells that need to be protected are in columns, but I need to allow rows
to be deleted. I tried your suggestion, but Excel told me "You are trying to
delete a row that contains a locked cell".

Is there any way around this?

Thanks in advance for your help!

Dan

"DNA" wrote:

Lock the cells you don't want them messing with and make sure you unlock
ALL other cells (all cells by default are already locked).

Protect the sheet and under the sections "Allow all user of this worksheet
to", make sure you uncheck "Select locked cells"

HTH

I was thinking the rows that contained important information (i.e., price,
etc.) would be rows you didn't want them to alter/delete. Is that
correct?

Overall, I guess what I'm asking is, the rows they are allowed to delete,
what type of data is in those rows?

If you want to delete rows that contain cells that are locked, you'll have to
unprotect that worksheet first.



Dan T wrote:

The cells that need to be protected are in columns, but I need to allow rows
to be deleted. I tried your suggestion, but Excel told me "You are trying to
delete a row that contains a locked cell".

Is there any way around this?

Thanks in advance for your help!

Dan

"DNA" wrote:

Lock the cells you don't want them messing with and make sure you unlock
ALL other cells (all cells by default are already locked).

Protect the sheet and under the sections "Allow all user of this worksheet
to", make sure you uncheck "Select locked cells"

HTH



--

Dave Peterson