Home |
Search |
Today's Posts |
#1
|
|||
|
|||
locking rows
I have a spreadsheet that performs statistics calculations on sheet 2 and is
protected, the operator enters data on sheet 1. The formulaes fail to work (result is #REF!) on sheet 2 because the operator has a habit of deleting rows on sheet 1 that upsets the named ranges. The problem persists even if I use ISERROR in my functions. I cannot protect sheet 1 because the operator needs to use the sort drop down menu. I need some VBA I think, but I don't know enough to do it quickly. Can anyone tell me how I can stop the operator deleting rows or is there a workaround here? many thanks Charlie Brown |
#2
|
|||
|
|||
I need some VBA I think
The problem with a macro approach is that the user can disable them. If you have Excel 2002 or 2003 you can use its Tools, Protection, Protect Sheet to allow sorting. To do this you'd have to unlock the cells that can be sorted and all other input cells. The user would not be able to delete rows though. -- Jim "Charlie Brown" wrote in message ... |I have a spreadsheet that performs statistics calculations on sheet 2 and is | protected, the operator enters data on sheet 1. The formulaes fail to work | (result is #REF!) on sheet 2 because the operator has a habit of deleting | rows on sheet 1 that upsets the named ranges. The problem persists even if | I use ISERROR in my functions. I cannot protect sheet 1 because the | operator needs to use the sort drop down menu. I need some VBA I think, but | I don't know enough to do it quickly. Can anyone tell me how I can stop the | operator deleting rows or is there a workaround here? | | many thanks | | Charlie Brown | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking a couple rows so when you do a delete shift row they dont | Excel Discussion (Misc queries) | |||
locking rows at top of chart | Excel Discussion (Misc queries) | |||
locking rows at top of chart | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
How to view tiled Excel worksheets by locking rows for scrolling . | Excel Worksheet Functions |