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.

"-" wrote:

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.


"rmayer" wrote in message
...
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?