Prevent row insertion

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

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?

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?