Checkboxes keep moving left!

[Jeff Wright]

Greetings!

In my spreadsheet, I have a sheet (called, say, "Edging") with four
checkboxes, one placed on each side of a rectangle. When I close out the
file and then re-open it, the four checkboxes become flush-left to the
screen, while the rectangle stays correctly placed in the center of the
screen. I've tried all options in the Properties menu to try to correct this
problem (e.g., lock, left, top, autoload, etc.), but nothing seems to work.

I should mention, for whatever it's worth, that to get to the "Edging"
sheet, a macro is run from another sheet which takes the user to the
"Edging" sheet, where it hides three columns. But the columns that the macro
hides does not include the checkboxes or rectangle.

I'm at my wit's end trying to figure out how to correct this erratic
behavior. Any help is greatly appreciated.

Thanks,

Jeff

 

[TJTH - ExcelForums.com]

I don't have english Excel but here goes

Try right mouse button over the checkbox and choose the last optio
from popup and from the form that opens (3 page in Excel 97) you ca
choose if objects movements are related to cells

 

[Dave Peterson]

This doesn't sound like an exact fit, but you may want to check it out:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

 

[Jeff Wright]

Dave, I read the article, which suggests that you select the "Move and size
with cells" option in the Format Control area of the Control Tool Box. I
tried this and, so far, the checkboxes are remaining in place!

Thanks for your time and research on this topic, Dave!

Jeff