Excel 2002 and 2003 give you many options to select from when protecting sheets.

Unfortunately you are using Excel 2000 so cannot benefit from these options.

You wouldn't want to use the "insert rows" option in any case. That option
allows users to insert rows in a protected sheet.

In Excel 2000, just protect the worksheet to prevent rows being inserted.

ToolsProtectionProtect sheet.


Gord Dibben MS Excel MVP


On Tue, 10 Oct 2006 08:02:02 -0700, Alex wrote:

Select "insert new rows" where?

"smw226 via OfficeKB.com" wrote:

Hi Alex,

If you protect your workbook and check "insert new rows" this will work

Thanks,

Simon

Alex wrote:
Is there a way to do this in 2000? Thanks.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1