worksheet protection

[Guest]

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

 

[Alan]

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.

 

[Dave Peterson]

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.

 

[Alan]

Nice one Dave, We live and learn!
Regards,
Alan.

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.