Checkbox question
can you "lock" a checkbox to its linked cell in regards to height, width,
and position?
In other words once placed, the checkbox would cover the cell, and if the
size or position of the cell is changed the size/position of the box would
alter with it.
if so:
what is the setting?
how would this need to be noted in VBA?
For Each rCell In rng
With SH.CheckBoxes.Add(rCell.Left + 4, _
rCell.Top - 2, 0, 0)
.Caption = ""
.LinkedCell = rCell.Address(0, 0)
End With
|