Lock Worksheet - Insert Row

[Roj47]

Morning all

I have a protected Sheet, but apart from inserting information into cells; I need to be able to insert additional rows.

Is there a way to do this without letting users remove the protection?

Thank you.

PS The number of rows is not a set number.

 

[hamonoakira]

When you press Alt T-P-P you could check "Insert rows"

 

[Yahya]

Yes
you can allow user to do it
when you protect you sheet from Protection Dialog Box Check Insert Rows
then put your password

 

[Roj47]

Thank you for the quick replies; however the screen ALT T, P, P allows the following check boxes:

Contents
Objects
Scenarios

I have tried unchecking these, but the only time I can insert a row is at the same time as being able to change the width of columns.

Only just realised as well; the hide row/ column function is unavailable with protect sheet which I require too.

Sorry for the inconvenience

 

[Roj47]

I do not think I was too good explaining my problem, so hoping I am more clear.

The sheet my staff use grows over time with more information, so we all click and insert rows as required.
The rows are usually entered at the end, but quite often between existing information.

What I am finding on this report is that the staff are increasing the column widths to fit the extra letter into a description column.
Using wrap function makes the document unsightly, so all I am after is preventing column widths being changed, but allowing the functions of insert row and hide row.

I have scoured Google, but it only advises protect sheet which works except we are unable to hide or insert.

I appreciate any assistance in saving me formatting documents issued to have a standard in the company.

Kind regards

 

[Yahya]

Yes
you can allow user to do it
when you protect you sheet from Protection Dialog Box Check Insert Rows
then put your password

did you try my suggestion

to activate Protect dialog Box for review --> Protect sheet

 

[Roj47]

I am afraid that I could not locate any reference to rows and a check option.

Trying to find what version of Excel I am using, but appears an old one. 2003 perhaps.

Ah.... I am on 2000... That is not good!

 

[Yahya]

i am working on Excel 2010
but
in Excel 2003
from Tools --> Protection --> Protect Sheet
you will get this screen

 

[Roj47]

Thank you.

I know what to do and that's get a recent upgrade for Excel from work.

I am definitely on Excel 2000, so really out of touch with it.

Thank you again.

 

[Yahya]

Thank you.

I know what to do and that's get a recent upgrade for Excel from work.

I am definitely on Excel 2000, so really out of touch with it.

Thank you again.

you are welcome

i am sure you will get help here