storing data

[cocopops2001]

I would like a way of storing data without saving it into a cell, ie some application memory or something?

what i have are calculation sheets and i would like a way of saving the variables so that if they are altered by the user a text box(or a message in a cell) will appear telling them so. any suggestions. I already have one set up where it sums the variables and compares them using an =IF in excel but wold like something that is a bit more secure

 

[lenze]

Have you considered using a "Defined Name"? You can define a name that refers to a constant. Open the New Name diaolg and enter a name (say TaxRate) For Refers to , enter the rate (say 0.08), Now in your formulas, you would use something like

=D3*TaxRate

lenze