Protected Row-Oriented Data Entry

I need a way to protect a sheet and to allow for convenient row-oriented data
entry...

I have a data entry sheet to be used by me and colleagues, where we'll enter
data one row at a time. Some of the fields in the rows are to be filled out
(unprotected) by users and some are calculated/referenced-in (protected). I
really like the Excel List functionality that, when active, has the asterisk
in the first column, last row, conveniently copying down formulas and formats
as soon as you start entering new data there.

As soon as I protect the worksheet (checking all the check-boxes including
"Allow Insert Row"), the "add-entry" row goes away.

A) Is there a way to allow for the add-entry functionality while the sheet
is protected?

B) If not, is there a different way to allow for protection and easy
row-oriented data-entry? (The only other idea I have is to create a whole
slew of dummy rows, but I'd like that to be a last resort.)

I'm using Excel 2003 on Windows XP, SP1.

Cheers,
....paul monette...

I don't know if this is of any help, but you can prevent row insertion and
leave the worksheet otherwise unprotected:


Go to row 65536 and enter any data. Excel will not allow row insertion
until this data is removed. If you desire, you can protect this cell.
--
Gary's Student


"Paul" wrote:

> I need a way to protect a sheet and to allow for convenient row-oriented data
> entry...
>
> I have a data entry sheet to be used by me and colleagues, where we'll enter
> data one row at a time. Some of the fields in the rows are to be filled out
> (unprotected) by users and some are calculated/referenced-in (protected). I
> really like the Excel List functionality that, when active, has the asterisk
> in the first column, last row, conveniently copying down formulas and formats
> as soon as you start entering new data there.
>
> As soon as I protect the worksheet (checking all the check-boxes including
> "Allow Insert Row"), the "add-entry" row goes away.
>
> A) Is there a way to allow for the add-entry functionality while the sheet
> is protected?
>
> B) If not, is there a different way to allow for protection and easy
> row-oriented data-entry? (The only other idea I have is to create a whole
> slew of dummy rows, but I'd like that to be a last resort.)
>
> I'm using Excel 2003 on Windows XP, SP1.
>
> Cheers,
> ...paul monette...

That's a neat trick, but I actually want just the opposite effect.

I want the sheet to be protected (so that me and my colleagues don't futz
with the formulas) but I want adding a new row (with the formulas) to be as
easy as possible.

Cheers,
....paul monette...


"Gary''s Student" wrote:

> I don't know if this is of any help, but you can prevent row insertion and
> leave the worksheet otherwise unprotected:
>
>
> Go to row 65536 and enter any data. Excel will not allow row insertion
> until this data is removed. If you desire, you can protect this cell.
> --
> Gary's Student
>
>
> "Paul" wrote:
>
> > I need a way to protect a sheet and to allow for convenient row-oriented data
> > entry...
> >
> > I have a data entry sheet to be used by me and colleagues, where we'll enter
> > data one row at a time. Some of the fields in the rows are to be filled out
> > (unprotected) by users and some are calculated/referenced-in (protected). I
> > really like the Excel List functionality that, when active, has the asterisk
> > in the first column, last row, conveniently copying down formulas and formats
> > as soon as you start entering new data there.
> >
> > As soon as I protect the worksheet (checking all the check-boxes including
> > "Allow Insert Row"), the "add-entry" row goes away.
> >
> > A) Is there a way to allow for the add-entry functionality while the sheet
> > is protected?
> >
> > B) If not, is there a different way to allow for protection and easy
> > row-oriented data-entry? (The only other idea I have is to create a whole
> > slew of dummy rows, but I'd like that to be a last resort.)
> >
> > I'm using Excel 2003 on Windows XP, SP1.
> >
> > Cheers,
> > ...paul monette...