| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking cells with formulas
I've got a s/sheet where here are some cells with the RAND function in them.
If a user enters a number in cell j2 the sheet runs and all is OK. However the results change if a user enters any thing in any other cell and presses enter. Is there anyway to prevent this so that the cells change only if J2 is changed? Cell locking does not do this unfortunately. Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locking formulas | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| Locking Formulas to Cells | New Users to Excel | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| locking formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
