worksheet protection

how do I prevent loss of cell formula protections when a protected worksheet
is copied to another location?

I don't think you can, although I may be wrong. If someone copies each
worksheet to a new workbook the protection is gone and they have a copy of
your work. It can be done using code, but that relies on the user opening
the workbook with macros enabled. If they open it with macros disabled they
can do as they wish, so that really isn't a viable option unless you arrange
the code to make the workbook of no use unless macros are enabled. This is
OK for casual and/or inexperienced users who don't really want to break into
your workbook, but XL protection is very weak and easily overcome by an
experienced user who has the motivation to break the protection,
Regards,
Alan.
"yemi" <yemi@discussions.microsoft.com> wrote in message
news:F109CCA4-6E73-44F2-9CDA-1E9C6B35B0D7@microsoft.com...
> how do I prevent loss of cell formula protections when a protected
> worksheet
> is copied to another location?

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

Nice one Dave, We live and learn!
Regards,
Alan.
"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:428E5001.3C7B75D@netscapeXSPAM.com...
> 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