Number of Macro making Excel Default Shortcuts slow

Hi,

I have a lot of macros in my workbook (Excel 2010). The are used on buttons for navigation through out the excel file. When assigning the macros I do NOT create short cuts for them. The macros are very basic:

Sub Finance_InputsSection()
    ActiveSheet.Range("A2").Select
End Sub

When I highlight cells and right click and copy using the mouse- it happens instantly. When I click Find in the ribbon the search dialog box open instantly also. However when I highlight cells and tap short cut Ctrl + c it lags for about 3-4 seconds. The same when I tap Ctrl + f. I created a blank workbook and just simply copied in the VBA code. Same issue. This leads me to believe that when I tap Ctrl+c it loops through all my macros to see are any short cuts assigned and hence the lag.

I have created a number of modules and broken my VBA code in smaller chunks but still the same.

Any ideas?
Kevin CryanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RobOwner (Aidellio)Commented:
Can you provide the workbook in question?  Kind of hard to reproduce without it.
0
Kevin CryanAuthor Commented:
Hi Rob.

If you create a blank Excel 2010 or 2013 macro enabled workbook and paste in the following attached sample macros into a module. If you tap Ctrl + c or Ctrl + f you should see the lag. But if you right click a cell with your mouse and go copy you shouldn't experience any lag.

Let me know if you need any more info.
0
Kevin CryanAuthor Commented:
Sample File with macros
SampleMacros.txt
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

RobOwner (Aidellio)Commented:
As the shortcuts are inherently linked to the macros, Excel searches through them all and I couldn't find anywhere to turn it off.

One way around it, is to disable all Ctrl+[key] combinations.  I've tested and included the code below.  You can still use Ctrl+Insert for Copy, Shift+Insert for paste, Shift+Del for Cut

Sub DisableShortCutKeys()
'Disable Ctrl-a to Ctrl-z
Dim x As Integer
For x = 97 To 122
Application.OnKey "^" & Chr(x), ""
Next x
End Sub

Sub EnableShortCutKeys()
Dim x As Integer
For x = 97 To 122
Application.OnKey "^" & Chr(x)
Next x
End Sub

Open in new window

0
Kevin CryanAuthor Commented:
Hi Rob,

Thanks for reply. Unfortunately I couldn't say to the users that the most common shortcuts of Ctrl+c and Ctrl+f are disabled. Looks like there is no fix for this.
0
RobOwner (Aidellio)Commented:
i know... i thought you may say that.. sorry i couldn't help further.From doing some testing its apparent that you cannot turn off shortcuts for macros.  Excel still goes through them all to see if there is one or not... seems very inefficient to me.
Can't be done.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kevin CryanAuthor Commented:
Thanks for the help Rob. I will maybe look at raising it with  Microsoft.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.