Hide formulas in cells

[Guest]

I need to find a way to hide formulas in cells, only showing the results.
I tried the hide, lock, protect sheet method, but then I cannot add data
without unprotecting the sheet each time.
With a password, and several workbooks that I reuse each week,
this is way to time consuming.
As example, I have data that I paste in from another program in column A
thru E
down to row 10. In F,G, & H I have formulas that produce results from each
row.
I need to be able to lock and hide the formulas in F thru H, row 1 to 10,
but still be able to
paste in new data (over write) each week in A thru E, and see the results in F
thru H. Its a sort of reuseable form.
I searched this group, but haven't found anything I could make work.
Could anyone post some code that might work for this?

 

[Guest]

Unprotect the sheet. Select columns A:E,
Format...Cells...Protection...Uncheck "Locked". Then reprotect the sheet.

Another option is to have all the formulas on a hidden, locked sheet, and on
the main sheet have simple formulas that link to the complex formulas.

 

[Guest]

note that hide formula via protection sheet menu only works in Excel 2002 or
later.
Excel 2000 or earlier version of Excel does not support it.

 

[Guest]

The OP seems to have that part solved:

note that hide formula via protection sheet menu only works in Excel 2002
or
later.
Excel 2000 or earlier version of Excel does not support it.

 

[Guest]

oops sorry maybe my post seems missunderstanding that's only considering

 

[Guest]

Thanks very much. This works. I didn't realize that by default the sheet
was "locked" in Excel 2000. That was what had caused the problem.
Again, thanks for the help.