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.


"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?

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.
--
Regards,

Halim



"-" 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?

The OP seems to have that part solved:

I tried the hide, lock, protect sheet method, but then I cannot add data
without unprotecting the sheet each time.


"Halim" wrote in message
...
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.
--
Regards,

Halim



"-" 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?

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

Halim



"-" wrote:

The OP seems to have that part solved:

I tried the hide, lock, protect sheet method, but then I cannot add data
without unprotecting the sheet each time.


"Halim" wrote in message
...
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.
--
Regards,

Halim



"-" 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?

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?