Disable Macro Shortcut

User avatar
cshenoy
StarLounger
Posts: 59
Joined: 08 Feb 2010, 14:26
Location: Lawrence, KS

Disable Macro Shortcut

Post by cshenoy »

At some point, I must have created a macro using the shortcut CTRL+Shift+End. Big mistake. I like to use that key combination to select all data to the end of a range, so now I'm trying to delete or at least change the macro key combination. Unfortunately, I can't find it. When I click on Macros in the developer tab, nothing shows up. I recently switched from EXcel 2007 to Excel 2010. I probably created the macro in 2007.

Please let me know if anyone has any ideas about changing the key combo or just deleting the macro!

Thanks
Cathy

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Disable Macro Shortcut

Post by HansV »

Press Alt+F11 to activate the Visual Basic Editor.
Press Ctrl+G to activate the Immediate window.
Type the following line (or copy / paste it), then press Enter:

Application.OnKey "+^{END}"

This will restore the built-in action of Shift+Ctrl+End.
Best wishes,
Hans