How To Disable Short Cut In Excel?

Throughout the last few days I have been operating fundamental and advanced Excel courses and one of the usual questions people are asking me is”What’s a very simple method to Disable a Short reduction Excel?” I have spent lots of time thinking to do this and there is a very simply solution.

Compose a macro

Let us say for instance you’re currently composing a Microsoft Excel template that you need different users to enter data into, however you wish to limit their capacity to utilize Cut, Copy and Paste’s features. Okay, so let me start off by examining your memory What’s the shortcut keystrokes for Cut, Copy and Paste if you do not know I will put you, they are –

Cut – [Ctrl] + [X]
Copy – [Ctrl] + [C]
Glue – [Ctrl] + [V]

To reevaluate these fundamental shortcuts we use a macro to accomplish this, keeping in mind that the macro will disable the cuts for that document, as long as you pick the alternatives that are best. Let’s go through the procedure to disable Cut, the cut.

The first step is to open a new spreadsheet in Microsoft Excel, then head into the Tools menu then choose Macro from the drop down menu, then select Record New Macro

The Record Macro dialog box will be visible. Type the text EliminateCut. Not that I did not have a space between the term Remove and Cut. The Excel application will come up with an error as in Microsoft Excel you’re NOT allowed to have spaces in macro names When you’ve got a distance.

Second measure click in the box that say shortcut key and then type in the letter X. In the Shop in Macro drop down menu the choice”This Workbook” should be selected. If it isn’t, be sure to select it from the drop down box or you also may disable Cut. Ultimately press on the OK button.

Word of caution Do Not Click or perform anything on the Worksheet. The Stop Recording toolbar must appear, simply click on the stop button that looks on a CD Player and also the recorder will stop.

In the event you place some text into a cell and deactivate the cell by pressing the [Enter] key, then return and click on it once and try your shortcut out. What you may find is that the cell is selected but if you click on another cell and attempt and paste the value by using [Ctrl] + [V] you will observe that the cell does not proceed and as this brief cut [Ctrl] + [X] is disabled.

I must note there are a number of limitations to this technique. Should you truly activate the cell and select the text from the mobile itself then attempt [Ctrl] + [X] you will discover that the text will likely be cut off, but if you use [Ctrl]+[X] to a normally selected cell you may notice [Ctrl] + [X] is disabled.