Bob
Again, I agree. Locking the sheet would be the best answer. However, I tried that with sheet protection and it interfered with the Sub Worksheet_Change code I have formatting the cell color elsewhere in the sheet. I figured that deleting some results with a sub providing it, the operator would only need reinput the values for the sub to provide the answer again. Whereas if the same person were to delete the formula, he or she would then have to figure the answer and enter it manually. If there is a way to lock those cells with formulae to prevent deletion without affecting the rest of the sheet, I'm all for it. But I was not able to get it to work that way. As always, suggestions greatly appreciated
Erik