title: Assign keyboard shortcut to macro inside the code
body: <p>I wrote a macro that change data in my excel, and I wrote other macro that 
  insert the first macro (I made) inside 1000+ different excels that don't have this macro. In regular situation I know how to assign keyboard shortcut to this macro: via "option" in Macro windows.</p>
  
  <p>but my goal is that the keyboard shortcut for Sub Single in Macro1 will remains also in all other excels, I think the best way is to do it in my code.
  I read the following articles but cant figure out where they want me to put the following code, so it will actually work?</p>
  
  <p>Thanks in advance for all helprs ..</p>
  
  <p><a href="https://msdn.microsoft.com/en-us/library/office/ff197461.aspx" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/office/ff197461.aspx</a>
  and that one: 
  <a href="https://stackoverflow.com/questions/9818047/excel-vba-assign-keyboard-shortcut-to-run-procedure">Excel VBA: Assign keyboard shortcut to run procedure</a></p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  
  Application.OnKey "^b", "Macro1"
  
  End Sub
  </code></pre>