How do you lock individual Cells so that user input cannot change it, BUT
it can change itself depending on Calculations from another cell on another
Sheet?

thx

Steve


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080116-0, 16/01/2008
Tested on: 16/01/2008 13:41:33
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com

Simply protect the sheet and the cell will update if the inputs to the
formula in it change but you wont be able to change it manually.

To leave other cells on the sheet un-protected, select them and then
format|cells|protection
remove the locked chackmark

Mike

"Steve" wrote:

How do you lock individual Cells so that user input cannot change it, BUT
it can change itself depending on Calculations from another cell on another
Sheet?

thx

Steve


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080116-0, 16/01/2008
Tested on: 16/01/2008 13:41:33
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com