title: Can I copy a sheet to a new workbook if it's hidden
body: <p>So maybe I'm just not getting something here, but I have a hidden worksheet that list several columns based on other hidden sheets. I'm trying to minimize user intervention... :-)</p>
  
  <p>I want to copy Hidden sheet 1 into a brand new workbook as an available sheet with the aforementioned values. Code that works when hiddensheet is visible:</p>
  
  <pre><code>Dim wbNew As Workbook
  
       Application.DisplayAlerts = False
      Worksheets("HiddenSheet").Copy
  
      Set wbNew = ActiveWorkbook
      With wbNew
          With .Worksheets(1).UsedRange
              .Value = .Value
          End With
          .SaveAs ThisWorkbook.Path &amp; "\"
          .Close True
       End With
  </code></pre>
  
  <p>So I'd like to still copy the sheet to a new workbook....just want to do it with the sheet hidden.  </p>
  
  <p>Any thoughts?</p>