Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes in Excel: Not moving with cell...
I have added multiple check boxes into a document, which appear to be working
well (i.e., I can check and uncheck.) The problem is when I go to insert a row - the check box does not move with the desired cell. I have tried Format Control/Properties/Object Positioning, but can't seem to get the check box to stay "assigned" to a given cell. Any thoughts would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes in Excel: Not moving with cell...
Are you sure the checkbox is completely within the cell?
And what type of checkbox did you use -- from the Forms toolbar or from the Control toolbox toolbar? And which option did you use: "Move and size with cells" or what? Sistercoo wrote: I have added multiple check boxes into a document, which appear to be working well (i.e., I can check and uncheck.) The problem is when I go to insert a row - the check box does not move with the desired cell. I have tried Format Control/Properties/Object Positioning, but can't seem to get the check box to stay "assigned" to a given cell. Any thoughts would be greatly appreciated. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes in Excel: Not moving with cell...
Dave:
Thanks - just distinguishing between the Forms and Control Toolbar did it for me. Have now recreated the check boxes using the Control Toolbar and all seems ready to go. Thanks! "Dave Peterson" wrote: Are you sure the checkbox is completely within the cell? And what type of checkbox did you use -- from the Forms toolbar or from the Control toolbox toolbar? And which option did you use: "Move and size with cells" or what? Sistercoo wrote: I have added multiple check boxes into a document, which appear to be working well (i.e., I can check and uncheck.) The problem is when I go to insert a row - the check box does not move with the desired cell. I have tried Format Control/Properties/Object Positioning, but can't seem to get the check box to stay "assigned" to a given cell. Any thoughts would be greatly appreciated. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes in Excel: Not moving with cell...
This is just a guess, but I'm wondering if the problem was really with the size
of the checkbox--that it wasn't completely in the cell??? Sistercoo wrote: Dave: Thanks - just distinguishing between the Forms and Control Toolbar did it for me. Have now recreated the check boxes using the Control Toolbar and all seems ready to go. Thanks! "Dave Peterson" wrote: Are you sure the checkbox is completely within the cell? And what type of checkbox did you use -- from the Forms toolbar or from the Control toolbox toolbar? And which option did you use: "Move and size with cells" or what? Sistercoo wrote: I have added multiple check boxes into a document, which appear to be working well (i.e., I can check and uncheck.) The problem is when I go to insert a row - the check box does not move with the desired cell. I have tried Format Control/Properties/Object Positioning, but can't seem to get the check box to stay "assigned" to a given cell. Any thoughts would be greatly appreciated. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula structure building ? check under the excel forum.... | Excel Discussion (Misc queries) | |||
Cell References | Excel Discussion (Misc queries) | |||
How do I tally checked check boxes in an Excel spreadsheet? | Excel Worksheet Functions | |||
How to align check boxes on an Excel sheet? | Excel Worksheet Functions | |||
how to incert multiple check boxes in excel | Excel Worksheet Functions |