title: Is there a way to check for non-visible, open Excel Workbooks?
body: <p>I have one open workbook with a button "SaveClose". I want the event on that button to close the entire Excel application if it is the last workbook opened. The thing is, there are possibility that there could be unknown personal.xlsb open or any other macro workbook open that is not visible. </p>
  
  <p>I want to know if there is any other workable Excel workbook opened. Is there a check for a not visible workbook? If it is the last workbook, close Excel application, if not close active workbook, here's what I got:</p>
  
  <pre><code>Sub CloseForceSave()
  
  'Save the workbook.
  ThisWorkbook.Save
  
  'If this is the only workbook opened in the current session, then...
  If Workbooks.Count = 1 Then "or Workbooks.Count = 2" to account for personal.xlsb
  '...quit Excel
  Application.Quit
  'Else...
  Else
  '...close the active workbook
  ThisWorkbook.Close
  End If
  
  End Sub
  </code></pre>