Difficulty hiding check boxes
 

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.

Difficulty hiding check boxes
 

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.

Don Madsen wrote:

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.

--

Dave Peterson

Difficulty hiding check boxes
 

If these are ActiveX controls (i.e. from the Controls toolbar), try
changing the value of the Placement property e.g. try Placement = 1.

"Don Madsen" wrote in message ...
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.