Lock formula??
 

Office 2k, win98se.

Would like to lock formulas in cells but not data that is entered/caculated.

Thanks,
L.

You can select the whole sheet (ctrl + a), do formatcellsprotection, uncheck
locked, click Ok. Now press F5, special, select formulas, click OK.
do formatcellsprotection, check locked, click OK. Now protect the sheet


Regards,

Peo Sjoblom

"L/P" wrote:

Office 2k, win98se.

Would like to lock formulas in cells but not data that is entered/caculated.

Thanks,
L.

Thanks for the info. Seems I have a "problem" with the delete key and
sometimes when I mean to delete contents of a cell I end up deleting the
formula's' instead!!!

Again, thanks,

L.



"Peo Sjoblom" wrote in message
...
You can select the whole sheet (ctrl + a), do formatcellsprotection,
uncheck
locked, click Ok. Now press F5, special, select formulas, click OK.
do formatcellsprotection, check locked, click OK. Now protect the sheet


Regards,

Peo Sjoblom

"L/P" wrote:

Office 2k, win98se.

Would like to lock formulas in cells but not data that is
entered/caculated.

Thanks,
L.