Prevent row insertion
 

Is there a way to prevent someone from inserting rows into a worksheet?

Prevent row insertion
 

You can save the file with a password for opening and a password for
modifying, each one being different. You can then dispense the appropriate
passwords to each user according to the type of access you want to give them.

Or you can also use protection to produce the same results. Just unprotect
the cells you want data entered into from the Cell Formatting dialog box and
then turn on protection and assign a password.

The row and column insert options will be grayed out in the menu.
--
Kevin Backmann


"Kathy" wrote:

Is there a way to prevent someone from inserting rows into a worksheet?

Prevent row insertion
 

Thank you Kevin,

I do unprotect the cells I want them to enter data in, but someone inserts
more rows into the spreadsheet and I want to stop their ability to do that.

"Kevin B" wrote:

You can save the file with a password for opening and a password for
modifying, each one being different. You can then dispense the appropriate
passwords to each user according to the type of access you want to give them.

Or you can also use protection to produce the same results. Just unprotect
the cells you want data entered into from the Cell Formatting dialog box and
then turn on protection and assign a password.

The row and column insert options will be grayed out in the menu.
--
Kevin Backmann


"Kathy" wrote:

Is there a way to prevent someone from inserting rows into a worksheet?