View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Lists on a protected worksheet

Hi,

When a spreadsheet is protected in 2003 you can not add rows to it by moving
to the bottom cell of the list. The best you can do is allow the user to
Insert Rows (in the Spreadsheet Protection area and unprotect the cells in
the List area (Format, Cells, Protection) and then tell them to Insert a row
within the list area.
--
Cheers,
Shane Devenshire


"thebaldsoprano" wrote:

We use Excel 03. When I protect my worksheet my list stops automatically
generating new rows. I've given permissions for people to insert & format
rows. What do I need to do?