title: Excel - How to add checkbox with VBA and linking to cell next to it?
body: <p>I'm writing a schedule in Excel with a lot of conditional formatting which alerts me if a person gets overlapping tasks. If someone doesn't show up someone else has to take several spots at the same day, then I want to add that to the spreadsheet to remember that.</p>
  
  <p>The problem is that if I do so I get red cells alerting me, and I don't want that for passed dates. I thought that I might add a column called "ignoreErrors", or something like that, with checkboxes and if I check any of these Excel ignores the rest of the formatting rules. </p>
  
  <p>I found the following script <a href="http://www.extendoffice.com/documents/excel/901-excel-insert-multiple-checkboxes.html" rel="nofollow noreferrer">here</a> (I edited a little bit):</p>
  
  <pre><code>Sub AddCheckBoxes()
      On Error Resume Next
      Dim c As Range, myRange As Range
      Set myRange = Selection
      For Each c In myRange.Cells
          ActiveSheet.checkboxes.Add(c.Left, c.Top, c.Width, c.Height).Select
          With Selection
              .LinkedCell = c.Address
              .Characters.Text = ""
              .Name = c.Address
          End With
          c.Select
      Next
      myRange.Select
  End Sub
  </code></pre>
  
  <p>When I add the checkboxes I get a range of checkboxes, but with the cell value (TRUE or FALSE) in the background. I don't want that. I thought I would link the checkboxes to a cell in the column next to it, and hide that. 
  Is that possible?</p>