Thread: Hide a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan.M Alan.M is offline
external usenet poster
 
Posts: 3
Default Hide a formula

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