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:
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.