| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent duplicate entries in Excel 2000 | Excel Discussion (Misc queries) | |||
| Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| Send to from excel 2003 after upgrade from Office 2000 | Excel Discussion (Misc queries) | |||
| Activate method of Worksheet class fails in Excel 2000 | Excel Discussion (Misc queries) | |||
| Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
Hybrid Mode
