Protection Issue

  • Thread starter Thread starter Shafeek.Khalidh
  • Start date Start date
S

Shafeek.Khalidh

Hi, I've an excel file. It has some rows in it.

I need to protect that rows with a password. but others should be able to
add new rows at the end, they should not add any rows among already existing
rows.

Is it possible to protect the excel this way, if yes, please help.

Thanks...Shafeek.Khalidh
 
Shafeek,

If the users need to insert the new rows at the end, they'll not be able to
if you've protected the sheet with inserting rows not allowed. If they're
only to type in new stuff, thus creating new rows (instead of using the
insert command), you could unlock all the rows below your existing rows
(Format - Cells - Protection - Locked unchecked), then protect the sheet
(Tools - Protection - Protect sheet). But the newly filled-in rows will not
be protected -- the protection formatting will have to be set back to locked
for that to happen.

For something this specific, a macro could be used to do the inserting. It
could look for the end of the existing data and determine if the user is
trying to insert a row among the existing rows, and refuse to do so, or if
it's OK to insert, it would unprotect the sheet, insert the row, reprotect
the sheet.
 
Thanks Earl for your quick reply.

I've protected the sheet with bellow conditions.
1) Tools - Protection - Protect sheet - Allow users to edit ranges & then
2) Tools - Protection - Protect sheet (As you said)

users can add fields, not insert a rows
Thank you for your help

Shafeek.Khalidh
 
Back
Top