VBA to Restrict Excel File Copy, Paste, Cut, DragNdrop & Move Sheet

Hello,

I am looking for simple VBA Codes to execute upon opening an excel file to prevent user from following tasks:
- Cut
- Copy
- Paste
- Drag and Drop
- Move/Copy Sheet

The codes should run automatically upon opening the file without any prompt.

Appreciate any help.

Hi

The following code disables Cut, Copy and Paste and *I think* drag and drop but I'm not 100% sure what you mean by that.

This needs to be placed in the "ThisWorkbook Module" and the Workbook will need to be saved and reopened before it takes effect;

Please Login or Register  to view this content.

The only way I know to stop people from moving and copying a sheet is to disable the menu completely, this is done by;

Please Login or Register  to view this content.

If you want this to work in conjunction with disabling Cut, Copy and Paste then you'll need to replace the two Subs in the first set of code and use them like this;

Please Login or Register  to view this content.

Okay let me try this