Rules for locking controls

D

DocBrown

I can't quite figure out what is happening and why. I'm makng a sheet with a
bunch of Form Controls Checkboxes. In the cells next to the boxes I'm added
text be associated with the checkbox. I'm not using the text field available
in the control because I want to be able to cut and paste and use other
normal Excel cell behavior of cells next to the checkboxes.

Somehow, I've gotten some text cells linked to the checkbox control. When I
cut and paste the text cells, the checkboxes are cut and pasted with them.
But there are other cells that LOOK the same with checkbox next to text, but
these checkboxes DON'T get cut and pasted with the text cells.

Is there something going on about ajacent cells or something?

What's causing the cells to be linked
 

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

Create form with checkbox les that expand and collapse sections of the form? 0
How to paste this down? 3
Columns appearing from nowhere, formatting going weird 0
Select Text to End of Footnote 9
Code to cut a paragraph that's followed by a table 2
Word macro that can call cells out of Excel for a find and replace 0
Cumulative formula for word table 0
Add a checkbox to a spreadsheet 2

Top