View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
smw226 via OfficeKB.com smw226 via OfficeKB.com is offline
external usenet poster
 
Posts: 98
Default Prevent users from adding rows in Excel 2000

Hi,

Sorry:

Goto: ToolsProtectionProtect 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

Alex wrote:
Select "insert new rows" where?

Hi Alex,

[quoted text clipped - 5 lines]

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