You can choose to hide the formulas when you lock the cells.
Format|cells|protection tab|Check Hidden
Then if you copy|paste the cells, they will be pasted as values.
And if you copy the whole sheet (Edit|Move or copy sheet), the formulas are
still hidden.
Be aware that worksheet protection isn't a security measure--it's usually just
used to keep users from overwriting formulas/labels.
That worksheet protection is easily broken.
yemi wrote:
how do I prevent loss of cell formula protections when a protected worksheet
is copied to another location?
--
Dave Peterson
|