Forum Discussion

JoopH's avatar
JoopH
Copper Contributor
Aug 18, 2022

How to replace an existing shortcut?

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.

excel
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Aug 18, 2022

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

Resources