How can I protect the formula and still let the user enter data in it?

How can I eat my cake and have it too? You can't. For your second question
I'd suggest you have a pure copy of your input area are hidden off somewhere
and copy it on top of the real input area via macro when needed.

--
Jim
"Enrique Mahecha"
<Enrique.Mahecha.20gmim_1135285800.9505@excelfor um-nospam.com wrote in
message news:Enrique.Mahecha.20gmim_1135285800.9505@excelf orum-nospam.com...
|
| Hi everyone.
|
|
| You have cell where values are entered, but it has a formula in it. How
| can I protect the formula and still let the user enter data in it?
|
| Or
|
| How do I RESET the table to its orginal state. Say all cells should be
| set to "o" or "empty" and everything, formulas, formatting for the
| entire table goes back to when first opened.
|
| Please see Pic in attachement (having problems with my server uploading
| the file). Pls let me know if get to see the pic, I am learning...
|
| TIA
|
| Enrique
|
|
| +-------------------------------------------------------------------+
||Filename: Excel cells in magenta.jpg |
||Download: http://www.excelforum.com/attachment.php?postid=4145 |
| +-------------------------------------------------------------------+
|
| --
| Enrique Mahecha
| ------------------------------------------------------------------------
| Enrique Mahecha's Profile:
http://www.excelforum.com/member.php...o&userid=10276
| View this thread: http://www.excelforum.com/showthread...hreadid=495619
|