You have the problem right, unfortunatly Im having a heck of a time finding
a solution. thanks, will keep you posted
--
Brose


"Gord Dibben" wrote:

brose

Have I got this right?

You have a formula in a cell and you want to edit that cell without making any
changes.

You know there's a way for this to work.

Post back when you get it done so's the rest of us can learn, please.

Perhaps show us what the formula looks like and what you want to edit.


Gord Dibben Excel MVP


On Thu, 28 Apr 2005 13:12:03 -0700, "brose"
wrote:

Thank you, i still fall into the same problem though because if the user
changes a cell it will overide the =A1 formula. or am I missing something?
I know theres a way to make this work so thanks for any and all help
--
Brose


"bj" wrote:

No But: you can have your calculations in one set of cells. In another set
of cells reference the original set. (=A1 etc) and have the second set be
your Display set.

You can then write over the second set as needed, and "refresh defaults" by
re referencing the original set.

Ha

"brose" wrote:

Is it possible to protect a formula and still be able to edit the contents in
the cell without changeing the formula.--
Brose