Aug 18 2022 05:24 AM - edited Aug 18 2022 05:26 AM
Hello,
I would like to change the SHIFT + SPACE shortcut with my own macro. I am using Excel 365.
I have tried opening the Visual Basic tab and adding a new Sub called createShortcut with "Application.OnKey "^ ", "EntireRow"" in it but this doesnt work.
Any help would be greatly appreciated!
EDIT: I would also like to use this new shortcut in every future Excel project I open.
Aug 18 2022 05:53 AM
The code for Shift+Space is "+ " instead of "^ " since ^ is Ctrl.
To be able to access the macro in all workbooks, store it in an add-in (*.xlam) and load the add-in in File > Options > Add-ins > Manage...