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?

 

[My Aswer Is This]

And your trying to run this Macro in the same Workbook the Macro is in?

 

[vbabeginner92]

The macro is stored in my personal workbook. I opened a new workbook and the macro will work but the shortcut key does not.

 

[Logit]

.
In the new workbook, did you place your Shortcut Key macro in ThisWorkbook ... Workbook Open ?

Option Explicit


Private Sub Workbook_Open()
    'your Shortcut Key Macro here
End Sub

 

[vbabeginner92]

I am not quite following. What if I have several short cut keys to assign?

 

[Logit]

.
Well, one way to activate all of your short cut keys would be to place
them in the same location I described previously.

Option Explicit


Private Sub Workbook_Open()


    	'your Shortcut Key Macro here


	'another short key macro here


	'and another key macro here


	'and then another one also


End Sub

Do the other short cut keys work ok and this single short cut does not ?

 

[My Aswer Is This]

If you have your Macro in your Personal workbook it should work in any workbook.
With the shortcut key

But if you have the same Macro with the same shortcut in your personal workbook and your current workbook there may be a conflict.

 

[vbabeginner92]

None of them work. I’ll try that!

 

[vbabeginner92]

All different macros with different short cuts.

 

[vbabeginner92]

Still doesn't work. Any other suggestions?