Difficulty hiding check boxes

  • Thread starter Thread starter Don Madsen
  • Start date Start date
D

Don Madsen

If rows 18 to 22 of sheet contain a check box (or check boxes) and I hide
those rows, then suddenly a checkbox appears in one or more of the rows
following row 22. Why is this happening? Is there any way to prevent the
appearance of these "extra" check boxes? Suggestions will be appreciated.
 
If I used the checkbox from the ControlToolbox toolbar (but not the Forms
toolbar), I could rightclick on it and select Format Control. Then on the
Properties Tab, I could select "move and size with cells".

Then the hiding of the row, hides the checkbox.
 
If these are ActiveX controls (i.e. from the Controls toolbar), try
changing the value of the Placement property e.g. try Placement = 1.
 
Back
Top