Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I protect selected cells on my worksheet? | Setting up and Configuration of Excel | |||
Can I Protect Just A Few Cells On A Worksheet? | Excel Discussion (Misc queries) | |||
How Do I Protect A Worksheet But Allow Copying Columns | Excel Discussion (Misc queries) | |||
Is there a way to protect individual cells in a worksheet? | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) |