Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent users from adding rows in Excel 2000
Is there a way to do this in 2000? Thanks.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent users from adding rows in Excel 2000
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent users from adding rows in Excel 2000
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent users from adding rows in Excel 2000
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 |
#5
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) |