Copy Command

W

will07

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
 
R

RobN

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
 
Top