hide
 

how would i be able to hide part of a sheet that has formulas on it. i would
like to email this sheet to others but do not want them to view the
calculations?

thanks.

hide
 

Use sheet protection and set each of the cells with a formula in to hidden
(Format cellProtection and set Locked AND Hidden) set the cells you want the
users to edit as unlocked.

"help with excel" wrote:

how would i be able to hide part of a sheet that has formulas on it. i would
like to email this sheet to others but do not want them to view the
calculations?

thanks.

hide
 

Hi

The safest way would be to copy the dataPaste SpecialValues to another
sheet in the workbook, then mail this new sheet to others.

--
Regards

Roger Govier


"help with excel" wrote in
message ...
how would i be able to hide part of a sheet that has formulas on it. i
would
like to email this sheet to others but do not want them to view the
calculations?

thanks.