Hiding the Formulas alone

  • Thread starter Thread starter raja_turbine
  • Start date Start date
R

raja_turbine

Hi,

I have an excel sheet with lot of formulas.
I want the values of the formulas to be displayed, but NOT the formula
themselves.
The objective is, the user can see the results of the formulas but no
how the calculations work, what are the cells that are referenced i
the calculation, what is happening to the variables etc.
In other words, its something like a black box, where we have the inpu
and the output, and the user need not be aware of what is happenin
inbetween.

Thanks and regards,
Raj
 
I don't use xl2003, but maybe it was Don's string that caused confusion:

right click on the cell>format>properties>hidden,
then tools|protection|protect sheet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide Formula & Allow Copy 1
hide formula in cells till data is available for calc 1
Is there a way to use subscripts in my formulas? 4
Hide Formula 7
Run numerous calculations through a single formula 1
Expanding Date formula 1
Hiding Formulas in Formula bar 3
hiding formulas 2

Back
Top