Difficulty hiding check boxes

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.
 
D

Dave Peterson

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.
 
O

onedaywhen

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
Word OLE to check spelling in text box 1
Checking the Value of a Check Box in a Macro 0
Macro for checking data in a cell against another cell andcopying/pasting data 8
list or combo box 0
Check Box Question 1
Hiding checkboxes 1
Auto Copy Data from one worksheet to another 1

Top