Nice one Dave, We live and learn!
Regards,
Alan.
"Dave Peterson" wrote in message
...
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