I'm using Excel 2000 (so I can't lock ranges of cells through the menu bar), am not allowed by IT to use macros and will be creating this worksheet for people who really don't know Excel very well.
What I want to accomplish is to essentially create a calculator on a worksheet with a row of cells that will retain a formula even if the cell contents are deleted by the user using 'Clear Contents' or the Delete button.
Currently, erasing the cell contents this way will result in the formula also being erased.
This calculation task will only require one row of actual number inputting since the formula results will be hand-written onto a paper form. The user will then delete the cells and go on to the next paper form and enter the new numbers for that form.
Presently, I have A2:E2 with column labels, A3:E3 has the formulas (and I've made the row height very small so it doesn't accidently get deleted), A4:E4 is where the numbers from the paper form will be entered and D4 and E4 is where the formula will produce the calculations.
Now I just have to figure out how to lock the formula into A4:E4 so that the sheet users aren't constantly deleting the formula with the cell contents by the highly intuitive and vastly destructive Delete button or 'Clear Contents'.
I'm sure the ExcelGods must have envisioned this kind of thing but I can't figure it out since I'm only slightly more aware of Excel than the eventual inputters (but smart enough to come to you).
Heeeellpp (please)?
Betty
What I want to accomplish is to essentially create a calculator on a worksheet with a row of cells that will retain a formula even if the cell contents are deleted by the user using 'Clear Contents' or the Delete button.
Currently, erasing the cell contents this way will result in the formula also being erased.
This calculation task will only require one row of actual number inputting since the formula results will be hand-written onto a paper form. The user will then delete the cells and go on to the next paper form and enter the new numbers for that form.
Presently, I have A2:E2 with column labels, A3:E3 has the formulas (and I've made the row height very small so it doesn't accidently get deleted), A4:E4 is where the numbers from the paper form will be entered and D4 and E4 is where the formula will produce the calculations.
Now I just have to figure out how to lock the formula into A4:E4 so that the sheet users aren't constantly deleting the formula with the cell contents by the highly intuitive and vastly destructive Delete button or 'Clear Contents'.
I'm sure the ExcelGods must have envisioned this kind of thing but I can't figure it out since I'm only slightly more aware of Excel than the eventual inputters (but smart enough to come to you).
Heeeellpp (please)?
Betty