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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Protection 2
Move/Copy Worksheet with Macros 2
problems getting this macro to work 23
Prevent bypassing security by copy/pasting to new workbook 3
Copy sheet to different workbook 2
How to use multiple command button to copy user form data to multiple worksheet 0
Workbook protection 1

Back
Top