|
Locking Cells
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 |
Locking Cells
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 |
| All times are GMT +1. The time now is 06:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com