How do I make an auto save when information is entered into a cell

[Option Button]

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?

 

[Gord Dibben]

1. The file must be saved in order to preserve the 15 in S10

2. Lock S10 and protect the worksheet before saving.

3. Unprotect the worksheet if you want to change S10

All the above could be done through code if you wish.

1 and 2 can be done through event code when the number 15 is entered in S10

3 can be done via macro or event code.


Gord Dibben MS Excel MVP