How to replace an existing shortcut?

Visitor

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.

1 Reply

@JoopH 

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