Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to prevent the user from "playing" with the numbers until they find a
desired outcome from a model. To do that, let say I have in cell s:10 a blank cell where the user can enter the number of goods sold. Let say the user enters 15 in cell S:10 and press return. 1. Can that number 15 be permanently saved in cell S:10 once the user press the enter key without pressing the file saved command? 2. Let assume the user saves the model and reopens it. How can I make sure that 15 will always appear in cell S:10 of that model (even if saved under a different name) and can't be changed? 3. How do I override the permanently saved 15 in cell S:10 so that I can enter a different number of goods sold? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
show date only if information entered in cell | Excel Worksheet Functions | |||
Can Excel warn me if a cell already contains entered information? | Excel Worksheet Functions | |||
Freeze Cell Once Information is Entered | Excel Discussion (Misc queries) | |||
Can I make information entered in a cell erase recurringly? | Excel Discussion (Misc queries) | |||
Formatted Cell Changes Format When Information Is Entered | Setting up and Configuration of Excel |