Visual basic objects printing problem

[Thomas Hall]

I have a workbook with checkboxes created using Visual
basic. Every time I print, the checkboxes shift to the
left. I can either edit the document to put the boxes
back where they were or close without saving and reopen
the document and the formatting is restored. I checked
the properties and the objects show to be locked.

 

[Myrna Larson]

This is a bug in Office XP SP3. To fix it, you must put the boxes back where
they belong, then select each one and Format/Object and change from "Move but
don't size with cells" TO "move and size with cells". If you do this from the
Properties menu (for check boxes from the control toolbox), you can change the
placement setting from 2 to 1.

 

[Dave Peterson]

Just a reference for Myrna's post:

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