Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul
 
Posts: n/a
Default 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...
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default Protected Row-Oriented Data Entry

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...

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul
 
Posts: n/a
Default Protected Row-Oriented Data Entry

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...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
data entry form Excel Aart Dijkzeul Excel Discussion (Misc queries) 1 September 25th 05 01:57 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
data entry using functions?????? [email protected] Excel Discussion (Misc queries) 2 August 26th 05 02:46 PM
How do you create a selection box for data entry within excel Ligia Magnus Excel Discussion (Misc queries) 1 May 25th 05 08:10 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM


All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"