When I return to my spreadsheet after printing or doing a print preview, the
control box is no longer in the same place on my spreadsheet where I had
placed it, but has moved for some reason. Can anyone tell me why? Thanks.

1. Enter Design mode by pressing the Design button on the control box toolbar
2. Right-Click on the control (such as a combo box or check box) and click
on Format Control
3. In the Properties tab select one of three options:
- Move and size
- Move but don't size
- Don't move or size

Hope that helps, and if it does please rate my post.

"BellExcel" wrote:

When I return to my spreadsheet after printing or doing a print preview, the
control box is no longer in the same place on my spreadsheet where I had
placed it, but has moved for some reason. Can anyone tell me why? Thanks.

See

http://support.microsoft.com/d*efault.aspx?kbid=838910
Controls move to the left of the worksheet in Microsoft Excel 2002

but also see the discussion:
http://groups.google.co.uk/groups?lr...apeXSP AM.com


--

HTH

RP
(remove nothere from the email address if mailing direct)


"BellExcel" wrote in message
...
When I return to my spreadsheet after printing or doing a print preview,
the
control box is no longer in the same place on my spreadsheet where I had
placed it, but has moved for some reason. Can anyone tell me why? Thanks.