Hiding Formulas

E

EG

I would like to hide the formulas on my spread sheet so that someone using it
would not be able to see them. is there an easy way to do that?

thanks.

EG
 
R

Ron Coderre

Try this:

Select the cells with the formulas you want to hide

Then...From the Excel main menu:
<format><cells><protection tab>
Check: Hidden
(Also check: Locked if you want the cells protected)
Click the [OK] button

That will allow the formula result to be displayed....but, not the formula
when protection is turned ON.
<tools><protection><protect sheet>

An additional layer of security can be used:
If you set the custom number format of the cell to: ;;;
the returned value will be hidden with and without protection turned on.
To hide the formula, though, you'd still need to follow the above section's
instructions.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
E

EG

Yes! Thanks!

Ron Coderre said:
Try this:

Select the cells with the formulas you want to hide

Then...From the Excel main menu:
<format><cells><protection tab>
Check: Hidden
(Also check: Locked if you want the cells protected)
Click the [OK] button

That will allow the formula result to be displayed....but, not the formula
when protection is turned ON.
<tools><protection><protect sheet>

An additional layer of security can be used:
If you set the custom number format of the cell to: ;;;
the returned value will be hidden with and without protection turned on.
To hide the formula, though, you'd still need to follow the above section's
instructions.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


EG said:
I would like to hide the formulas on my spread sheet so that someone using it
would not be able to see them. is there an easy way to do that?

thanks.

EG
Click to expand...
Click to expand...
 
Top