Over the last few days I have been running basic and advanced Excel courses and one of the common questions that people are asking me is “What is a simple way to Disable a Short cut in Excel?” I have spent lots of time thinking about a non-programmatic way to do this and there is a very simply solution.
Write a macro
Let us say for example you are writing a Microsoft Excel template that you need various users to enter data into, but you want to limit their ability to use the features of Cut, Copy and Paste. Okay, so let me start off by testing your memory What is the shortcut keystrokes for Cut, Copy and Paste I will put you out of your misery if you do not know, they are –
Cut – [Ctrl] + [X]
Copy – [Ctrl] + [C]
Paste – [Ctrl] + [V]
Now to override these basic shortcuts we simply use a macro to do so, keeping in mind that the macro will only disable the short cuts for that document, as long as you choose the right options. Let us go through the process to disable the short cut, Cut.
The first step is to open a new spreadsheet in Microsoft Excel, then go to the Tools...
To view and download this full PLR article, you must be logged in. Registration is completely free. Once you create your account, you will be able to browse, search & downlod from our PLR articles database of over "1,57,897+" on 1,000's of niches and 200+ categories without paying a penny. Click here to signup...
