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" wrote in message
...
how do I prevent loss of cell formula protections when a protected
worksheet
is copied to another location?