Option Explicit
Sub Macro1()
Dim lngView As Long
Dim dblZoom As Double
Dim i As Long
Dim strLft As Single
Dim strTop As Single
Dim strWth As Single
Dim strHht As Single
With ActiveWindow
lngView = .View
dblZoom = .Zoom
.View = xlNormalView
.Zoom = 100
End With
With ActiveSheet
For i = 2 To 151 Step 1
With .Range("C" & i)
strLft = .Left
strTop = .Top
strWth = .Width / 2
strHht = .Height
End With
.CheckBoxes.Add(strLft, strTop, strWth, strHht).Select
With Selection
.Name = "Check Box " & i - 1
.Characters.Text = ""
.Placement = xlMove
.PrintObject = True
.Value = xlOff
.LinkedCell = "$D" & i
.Display3DShading = True
End With
Next i
End With
With ActiveWindow
.View = lngView
.Zoom = dblZoom
End With
End Sub