title: How to hide and copy a checkbox using vba
body: <p>I have the base column with the checkbox, (the D column in my code), and i want to copy that column with the checbox to the other columns, but the column D must be hide(all the data including the checkbox).</p>
  
  <p>the problem here is:</p>
  
  <ol>
  <li>i don't know how to hide the checbox, when i hide the column the checbox still visible.</li>
  <li>when i coppy the column the checbox in the colum does not be copied</li>
  </ol>
  
  <p>This is the fuction that i actually used.</p>
  
  <pre><code>    Private Sub cmdAddNewXref_Click()
      Columns("D:D").Select
      Selection.Copy
  
      i = 3
      Cells(2, i).Select
      Do
          i = i + 1
      Loop While Cells(2, i) &lt;&gt; ""
      Cells(2, i).Select
  
      'MsgBox ActiveCell.Column
  
      Columns(i - 1).Select
      Columns("D:D").Select
      Selection.Copy
  
      Columns(i).Select
      ActiveSheet.Paste
      Selection.EntireColumn.Hidden = False
  
      Application.CutCopyMode = False
  
      Range("A1").Select
      End Sub
  </code></pre>
  
  <p>but most importantly what i want to do, is possible?</p>
  
  <p>EDIT 1: actually thanks to Scott Holtzman i can hide the checkbox with the columns.</p>