title: Formula to identify invisible sheets
body: <p>I have the following simple Excel spreadsheet:</p>
  
  <pre><code>        A               
  1    Sheet1    =MID(CELL("filename",Sheet1!K1),FIND("]",CELL("filename",Sheet1!K1))+1,255)
  2    Sheet2    =MID(CELL("filename",Sheet2!K1),FIND("]",CELL("filename",Sheet2!K1))+1,255)
  3    Sheet3    =MID(CELL("filename",Sheet3!K1),FIND("]",CELL("filename",Sheet3!K1))+1,255)
  4    Sheet4    =MID(CELL("filename",Sheet4!K1),FIND("]",CELL("filename",Sheet4!K1))+1,255)
  5    Sheet5    =MID(CELL("filename",Sheet5!K1),FIND("]",CELL("filename",Sheet5!K1))+1,255)
  6
  7
  </code></pre>
  
  <p>In <code>Column A</code> there is a list of all sheets in the Excel file. <br> I list the sheets using the formula that you can see next to it.</p>
  
  <p>All this works fine so far.</p>
  
  <hr>
  
  <p>Now it can happen that some sheets in my spreadsheet are invisible (hidden). In this case I want that those sheets <strong>do not appear</strong> in the list above. Therefore, I wonder if there is a formula that can identify if a sheet is visible or not. Something like this:</p>
  
  <pre><code>IF MID(CELL("filename",Sheet1!K1),FIND("]",CELL("filename",Sheet1!K1))+1,255) = Invisible THEN ""
  </code></pre>
  
  <p>Do you have any idea how to solve this issue?</p>