| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
| Difficulty hiding rows | Excel Worksheet Functions | |||
| hiding data series with check/uncheck boxes | Charts and Charting in Excel | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Hybrid Mode
