Hello All,

As part of a security system I have set up, I need to prevent users from
copying any worksheets. I have protected the workbook, but the copy button
is still accessable in the edit drop down. Is there any way that I can
disable this action.

Thanks

One way....

1. Right click the sheet tab and choose View Code.
2. In the properties area on the left you'll find EnableSelection. Click on
that and a dropdown will appear.
3. Select xlUnlockedCells. (That way people will still be able to select
unlocked cells, etc.)
4. Protect the worksheet

Rob

"will07" wrote in message
...
Hello All,

As part of a security system I have set up, I need to prevent users from
copying any worksheets. I have protected the workbook, but the copy
button
is still accessable in the edit drop down. Is there any way that I can
disable this action.

Thanks