| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect formulas in locked cells from changing if data is moved
I have locked and protected a worksheet leaving only "Select unlocked cells"
checked. The problem is that if a user "moves" an entry in an unlocked cell, either by ctrl X or drag and drop the cell references in the locked formulae that referred to the original position change to the new position. Is there any way of preventing this without turning off the drag and drop functionality? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Viewing Formulas in Locked Cells | Excel Discussion (Misc queries) | |||
| Locked cells with Protect Sheet. | Excel Discussion (Misc queries) | |||
| Protect shouldn't default to "allow users to select locked cells" | Setting up and Configuration of Excel | |||
| sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
| Can I protect a spreadsheet from being deleted or moved? | Excel Discussion (Misc queries) | |||
Threaded Mode
