Copy Command

  • Thread starter Thread starter will07
  • Start date Start date
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
 
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
 
Back
Top