Hide formulas in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 
The OP seems to have that part solved:


Halim said:
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.
Click to expand...
 
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.
 
Back
Top