title: How to obtain workbook-scoped name?
body: <p>In Excel, i have defined two names. Both have the same name, but different scope and value. One is scoped to a sheet, the other to the workbook. </p>
  
  <p><a href="https://i.stack.imgur.com/ilETn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ilETn.png" alt="enter image description here"></a></p>
  
  <p>I'm unable to retrieve the book-scoped name, either in a cell formula, or in VBA. </p>
  
  <p>in VBA, the following returns the sheet-scoped name:
  <code>ThisWorkbook.names("myName")</code>
  <a href="https://i.stack.imgur.com/YHSbB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YHSbB.png" alt="enter image description here"></a></p>
  
  <p>in a cell, when i enter the following:
  <code>=book.xlsb!myName</code>
  Excel rewrites it as:
  <code>Sheet1!myName</code></p>
  
  <p>How to retrieve the workbook scoped name, in a cell formula and/or VBA?</p>