Y
yemi
how do I prevent loss of cell formula protections when a protected worksheet
is copied to another location?
is copied to another location?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.
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.
D
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.
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.
A
Alan
Nice one Dave, We live and learn!
Regards,
Alan.
Regards,
Alan.
Dave Peterson said: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.