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
|
|