In a protected worksheet allow users to delete rows

G

Guest

I have protected a worksheet and clicked the box to allow users to add or
delete rows but Excel won't allow it. When you return to the worksheet out of
protection the box can say users are ok to delete rows , but the delete
button on the right mouse click and the delete rows on the drop down menu
won't work.
 
I

Ian

This is possible in Excel 2002, but nothing earlier. This would mean
everyone using this version (or later).
 

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

How do you insert & delete rows in a protected worksheet? 1
Inserting and Deleting Rows in Excel 2
Expanding Grouped Rows when sheet is Protected 2
Insert/ delete row in protected worksheet 7
allow insert rows = false for only some of the worksheet 1
Delete Rows in a protected worksheet 2
Insert Copied Rows or Drag/Drop Formulas While Protected 2
Protection permissions 3

Top