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