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

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
--------
Message sent via www.excelforums.com

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

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

Jeff Wright wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)

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


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This doesn't sound like an exact fit, but you may want to check it out:
>
> http://support.microsoft.com/default...b;EN-US;838910
> Controls move to the left of the worksheet in Microsoft Excel 2002
>
> Jeff Wright wrote:
>>
>> 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
>
> --
>
> Dave Peterson
> (E-Mail Removed)