Prevent users from adding rows in Excel 2000

G

Gord Dibben

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.

Tools>Protection>Protect sheet.


Gord Dibben MS Excel MVP


Select "insert new rows" where?

smw226 via OfficeKB.com said:
Hi Alex,

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

Thanks,

Simon
Is there a way to do this in 2000? Thanks.
Click to expand...

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

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

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200610/1
Click to expand...
Click to expand...
 
S

smw226 via OfficeKB.com

Hi,

Sorry:

Goto: Tools>Protection>Protect Sheet...

This will then bring a box up which will ask you for a password and have a
list of options below. Ignore what I told you earlier and make sure "insert
new rows" does not have a tick next to it.

If there is no tick next to the action in the list, then they will not be
able to perform that action.

Thanks,

Simon
Select "insert new rows" where?
Hi Alex,
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...

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

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

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200610/1
 
Top