Hide a formula

Is it possible to hide a particular formula in a cell without protecting the worksheet?

Thanks.

-ep

Hi ep

You can use a trick that I use some times:
I put the formula in a cell that is way off to the side and then name the
cell, eg: "MyFormula" Then where your user can see you set that cell =
MyFormula.

Alternatively, write a Function in VBA and then protect the Project.

>
> Is it possible to hide a particular formula in a cell without protecting
> the worksheet?
>
> Thanks.
>
> -ep
>
>
> --
> edwardpestian
> ------------------------------------------------------------------------
> edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
> View this thread: http://www.excelforum.com/showthread...hreadid=568604
>
>

I'd prefer to write a function in VBA. Can anyone point me in the right direction?

Thx

-ep

Ed
What Alan is referring to is writing a User Defined Function or UDF.
That function would do the work for you and return a value to that cell that
holds the function. All that the user would see is the name of the function
and its argument. As Alan said, you can then protect the code so that the
user can't see it.
But be aware that Excel is not a secure platform nor is it intended to
be. Any kind of security measures you take can be over-ridden by anyone
with sufficient Excel knowledge. HTH Otto
"edwardpestian" <edwardpestian.2c2fyf_1154779506.5494@excelforum-nospam.com>
wrote in message
news:edwardpestian.2c2fyf_1154779506.5494@excelforum-nospam.com...
>
> I'd prefer to write a function in VBA. Can anyone point me in the right
> direction?
>
> Thx
>
> -ep
>
>
> --
> edwardpestian
> ------------------------------------------------------------------------
> edwardpestian's Profile:
> http://www.excelforum.com/member.php...o&userid=33809
> View this thread: http://www.excelforum.com/showthread...hreadid=568604
>

Hi,

Not sure if this helps but you could try a named range.

The link runs you through a simple example.

http://www.cpearson.com/excel/named.htm

VBA Noob

I think simply moving the formula to an inconspicuous place and defining the cell will suit the purpose.

Thanks for the help..

-ep