P
parteegolfer
Is there a way to protect formulas from being deleted when clearing cell
from current data?
from current data?
P
Paul B
parteegolfer, one way select the range you want to clear, then edit goto
special, select constants, Ok, delete
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"parteegolfer" <[email protected]>
wrote in message
news
[email protected]...
special, select constants, Ok, delete
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"parteegolfer" <[email protected]>
wrote in message
news
[email protected]...
G
Gerencsér Gábor
Typically you have your entry data in different column's cells than the
formulas.
If so, you can format the entry data cells as not locked.
Then you protect the sheet with password.
In this case the user can only delete the entry cells' contents and not the
formulas.
Cheers, Gabor
"parteegolfer" <[email protected]>
az alábbiakat írta a következõ hírüzenetben:
[email protected]...
formulas.
If so, you can format the entry data cells as not locked.
Then you protect the sheet with password.
In this case the user can only delete the entry cells' contents and not the
formulas.
Cheers, Gabor
"parteegolfer" <[email protected]>
az alábbiakat írta a következõ hírüzenetben:
[email protected]...