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