View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Hiding Formulas and Being Able to Make Changes

Using Excel 2003
Is there a way to hide the formulas, but still be able to make changes to
the cells without the formulas.
I followed the below instructions and ALL of the cells on the worksheet are
protected. The formulas are hidden, but a user cannot make any changes.

Select the range of cells whose formulas you want to hide. You can also
select nonadjacent ranges.

On the Format menu, click Cells, and then click the Protection tab.
Select the Hidden check box.
Click OK.
On the Tools menu, point to Protection, and then click Protect Sheet.
Make sure the Protect worksheet and contents of locked cells check box is
selected.

ANY help would be greatly appreciated.
Thank you, Karen