title: assign a shortcut key AND hide macro
body: <p>I am at a dead end, i have been trying to hide all macros, I have been able to do all macros that do NOT have a short Key assigned by Private Sub, but whenever i use Private on a macro that has a shortcut key assigned it doesn't not work, in fact, it disables the shortcut key</p>
  
  <p>I have tried </p>
  
  <pre><code>Private Sub Workbook_Open()
  Application.OnKey "+Q", "Macro1"
  End Sub
  </code></pre>
  
  <p>and that doesn't work, yes I placed it in This Workbook.....of course if i take Private out of the macro and run it works fine.  I have tried <kbd>^</kbd>+<kbd>Q</kbd> and that doesn't work either</p>
  
  <p>there has to be a way, isn't there?</p>