Macro works but shortcut key will not

[vbabeginner92]

I made a very simple macro.

Sub Yellow_Highlight()
Selection.Interior.Color = RGB(255, 255, 0)
End Sub

I then assigned it a shortcut key of CTRL+SHIFT+H

When I run the macro using F8 or Visual Basic it works fine. When I try to use the shortcut it does not work. Any suggestions?

 

[Logit]

.
Are you able to post your workbook to a CLOUD site (Dropbox, Amazon Cloud, Google, etc) for inspection and review ? Do not include any confidential information.

Also provide a list of the shortcut key macros and what they do.

 

[vbabeginner92]

Yes I will direct message you.

 

[My Aswer Is This]

Here is all you should need to do:
1.Create the Macro in any Workbook
2. In the Vba Project window select the Macro and drag it into the Personal folder
3.Now choose View from the ribbon
4.Choose Macros
4. Choose The Macro in the Personal Workbook
5. Choose Options and assign the Shortcut key.

6. Now close Excel
7.Choose save when your asked save changes to Personal Workbook

Now restart Excel and when you use the Shortcut key you assigned to the macro the Macro should run
You do not need to put script in ThisWorkbook Open