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
Disable Macro Shortcut
-
- StarLounger
- Posts: 59
- Joined: 08 Feb 2010, 14:26
- Location: Lawrence, KS
Disable Macro Shortcut
Cathy
-
- Administrator
- Posts: 78524
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Disable Macro Shortcut
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.
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
Hans