hidden formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xtrmhyper - 28 Jun 2005 08:13 GMT

can i hide the formula?

i want if i have a formula in A1= sum(a2:a10)
i want to see the user is "hyper" in formula not =sum(a2:a10)

tnx in advance

godspeed :cool:

Signature

xtrmhyper

Reply to this Message

Anne Troy - 28 Jun 2005 09:20 GMT

If you want the user to see "hyper", why not just type Hyper? What's the
point of the sum formula if you can't see its result?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> can i hide the formula?
>
[quoted text clipped - 4 lines]
>
> godspeed :cool:

Reply to this Message

Bob Phillips - 28 Jun 2005 09:52 GMT

Select your target cell
Go to Insert>Name>Define Name...
Add hyper as the names in workbook
Add =SUM(A2:A10) in the Refersto box
Exit

now just use

=Hyper

Signature

HTH

Bob Phillips

> can i hide the formula?
>
[quoted text clipped - 4 lines]
>
> godspeed :cool:

Reply to this Message