there is a very simple procedure to do this, kindly follow these steps:

STEPS:

1. Open the document or template where you want this shortcut key functionality.

2. Record the Macro:

3. Press Alt + F8 to open the Macros dialog.

If you have vba code:

1. click on developer tab

2. click on the record macro and  giev a name and saved it.

3. click on stop recording

4. go to Macros

5. click your desired macro

6. click on edit

7. write or paste your vba code

8. ctrl +S

10. closs all and save.

Assign the Macro to a Shortcut Key:

https://artisthindustani.blogspot.com/2025/08/how-to-use-vba-code-and-assign-macro.html