Hiding functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 15 Sep 2007 19:54 GMT

Hello again
I seem to remember someone saying that you could put all your functions in
cells that are hidden way down in the bottom of a sheet somewhere so that
knowone could delete or mess with them. and they would still perform the
calculation in the cell intended. like if I want A5 to give me the total of
A1 through A4 I could put that function in cell A300 That way if someone
tries to delete the answer I don't loose the function.

Signature

Thank You
Steve

Reply to this Message

JNW - 15 Sep 2007 20:10 GMT

A300=sum(a1:a4)
A5=A300

But I think protection would be a better, easier, and more efficient way to
do it.

Signature

JNW

> Hello again
> I seem to remember someone saying that you could put all your functions in
[quoted text clipped - 3 lines]
> A1 through A4 I could put that function in cell A300 That way if someone
> tries to delete the answer I don't loose the function.

Reply to this Message

steve - 15 Sep 2007 20:36 GMT

Ok thanks again I will try both ways

Signature

Thank You
Steve

> A300=sum(a1:a4)
> A5=A300
[quoted text clipped - 9 lines]
> > A1 through A4 I could put that function in cell A300 That way if someone
> > tries to delete the answer I don't loose the function.

Reply to this Message