Protect Sheet not allowing users to Insert/Delete rows

pliant

Board Regular
Joined
Jan 8, 2003
Messages
238
Hi,

I am using Excel 2003 and would like to Protect a sheet so that users can edit everything (eg. Insert/Delete rows/columns, Format rows/columns) except Locked Cells.

So I clicked on Tools > Protection > Protect Sheet > under Allow all users of this worksheet to: checked all boxes except "Select locked cells".

The locked cells are now protected however when I right click to add a row, the Insert and Delete items on the popup menu are greyed out.

I've found that I can insert a row by clicking the Insert > Rows in the top menu but can't find a way to delete it.

Does anyone know how to keep the items working in the right click popup?

Thanks!
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

pliant

Board Regular
Joined
Jan 8, 2003
Messages
238
Don't you mean check it?

The header of the checkboxes reads -->

Allow all users of this worksheet to:
here i have checked Insert Rows (and all others except Select Locked Cells)

Unchecking it would disable Insert Rows...
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
I thought you meant you wanted to disable insert action for the user
 

pliant

Board Regular
Joined
Jan 8, 2003
Messages
238

ADVERTISEMENT

Nope, I want everything enabled except for "Select locked cells"
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
I got your question now.. sorry for the delay... the problem is you are not allowinf the user select a cell naturally the right click is not allowing them to insert a row... let me think if there is a way to get around it
 

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
IS the reason you dont want the user select a cell so that they dont change the value? I guess in order to fix the problem I gotta know what is the reason you are allowing everything but not "select cell"
 

pliant

Board Regular
Joined
Jan 8, 2003
Messages
238
Mainly so that users can't change fields headers and title and so they can easily tab between the fields they are supposed to fill in.

But they have to be able to insert/delete rows because there are a few sections that they may need to expand.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,991
Messages
5,834,764
Members
430,319
Latest member
Excelhelppll

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top