Protect from copying cells or worksheet
 

You really can't ultimately. You can stop sheet copying with Tools,
Protection, Protect Workbook, except that the password can be broken easily.
And you can stop copying cells with a macro, but if the user disables
macros, then that doesn't work.

A VB project can be projected with a password and that's harder to break.
If the user doesn't know how to break it he can't separate the code from the
VB project.

--
Jim Rech
Excel MVP
"PKyle" wrote in message
...
| Is there a way to protect cells and or worksheet from copying and pasting
to
| a new worksheet ?
|
| (disable copy and disable copy/move functions in a worksheet)
|
| I have a macro that someone is trying to strip out of a file- to modify
the
| sheet to their desires- and I need to maintain document control for
| ISO.9001..
|
| Thanks
|
|