merlin_the_magician
Active Member
- Joined
- Jul 31, 2002
- Messages
- 480
need some serious Excel-knowledge here people…
I’m very proud of myself, for creating an awesome spreadsheet that is that bloody good it will be spread to everyone throughout the office … one minor thing however…
I have a few formula-cells that display specific info-text when selected, and display specific error-message when data is entered, because I limited input to ZERO characters, so overwriting is not possible.
Entering values is impossible, because of the validation, however it is possible to delete the formula.
How can I prevent formulas from getting deleted? I DO NOT want to use common password-protection, because I want to specify the error message myself by using validation.
Anybody know how to do this? Been searching the web, but no result…
This message was edited by merlin_the_magician on 2002-08-01 04:31
I’m very proud of myself, for creating an awesome spreadsheet that is that bloody good it will be spread to everyone throughout the office … one minor thing however…
I have a few formula-cells that display specific info-text when selected, and display specific error-message when data is entered, because I limited input to ZERO characters, so overwriting is not possible.
Entering values is impossible, because of the validation, however it is possible to delete the formula.
How can I prevent formulas from getting deleted? I DO NOT want to use common password-protection, because I want to specify the error message myself by using validation.
Anybody know how to do this? Been searching the web, but no result…
This message was edited by merlin_the_magician on 2002-08-01 04:31