Are the links in place - with a copy of the file - delete the checkboxes and try adding again
Option Explicit
Sub DelCheckBox()
ActiveSheet.CheckBoxes.Delete
End Sub
Public Sub chbox_forRows()''' Adds a checkbox to each row between two row numbers
Dim Frow As Variant: Dim Lrow As Variant
Dim i As Long
Dim str As String
str = InputBox("Enter first and Last row separated by -")
Frow = InStr(str, "-")
Frow = Left(str, Frow - 1)
Lrow = Right(str, Len(str) - InStr(str, "-"))
For i = Frow To Lrow
XAddCheckBoxes Cell:=Range("A" & i)
Next
End Sub
Private Sub XAddCheckBoxes(Cell As Range)
With ActiveSheet.CheckBoxes.Add(Cell.Left, _
Cell.Top, _
Cell.Width, _
Cell.Height)
.LinkedCell = Cell.Offset(, 0).Address
.Caption = Range(.LinkedCell).Row
End With
End Sub
Bookmarks