How do I disable the right mouse cut and paste facility?

DexonII

New Member
Joined
Sep 8, 2005
Messages
34
I need to be able to prevent any user from cutting and pasting data in one of my spreadsheets. I have protected it all, removed cut and paste from the options- edit tab, but you can still cut and paste with the right mouse shortcut key.

How do I stop this from being available?

Paul.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
ShortcutMenus(xlWorksheetCell).MenuItems("Cut").Delete

and similarly with Paste.
 
Upvote 0
VoG II,

Thanks, will this remove it permantly from all further files that are opened? or does it just do it for the spreadsheet used?

Approx 45 different people will use these files (200 files) through one "master" switchboard. I would still like to be able to use the short cut menu on other spreadsheets.

Also where do I paste the statement? In the work book declerations?

Paul
 
Upvote 0
Try

Code:
Application.OnKey "^{c}", ""        'Copy
Application.OnKey "^{v}", ""        'Paste
Application.OnKey "^{x}", ""        'Cut
 
Upvote 0
Yes, I would create a sub called Auto_Open in an ordinary module and put all the disabling code in it.
 
Upvote 0
Hi VoG,

I'm backagain! I have tried the code to disable the short cut keys and that works just fine!

However when I try the code for the shortcut menu Cut, Copy, Paste and Paste Special I get an error with the macro.

It says "Run time error "1004" Application defined or object defined error"

How do I get round this to make it work??

Paul.
 
Upvote 0

Forum statistics

Threads
1,217,346
Messages
6,136,044
Members
449,981
Latest member
kjd513

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top