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