Controls move to the left of the worksheet in Microsoft Excel 2002

Article translations Article translations
Article ID: 838910 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

When you insert a control over a cell in Microsoft Excel 2002, and then use Print Preview, the control is repositioned when you return to worksheet view. To insert a control over a cell, follow these steps:
  1. Start Excel 2002.
  2. On the View menu, point to Toolbars, and then click Control Toolbox.
  3. On the Control Toolbox, click the Command Button icon.
  4. Move the command button to cell H8.
  5. On the File menu, click Print.
  6. Click Print .
When you return to worksheet view, the command button has moved to the left, near cell B8.

Cause

This problem occurs after you install Microsoft Office 2002 Service Pack 3 (SP3). This problem does not occur in Office 2002 versions that are earlier than SP3.

Workaround

To work around this problem, configure the positioning properties of the command button to the Move and size with cells option. To do this, follow these steps:
  1. Right-click the command button, and then click Format Control.
  2. On the Properties tab, click Move and size with cells.
  3. Click OK.
By default, this option is set to the Move but don't size with cells option.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Resolution

How to obtain the hotfix

This issue is fixed in the Excel 2002 post-Service Pack 3 hotfix Hotfix Package May 6, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
829348 Excel 2002 post-Service Pack 3 hotfix package: May 6, 2004

Properties

Article ID: 838910 - Last Review: May 23, 2014 - Revision: 3.0
Applies to
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbfix kbui kbprint kbusage kbpending kbnofix kbqfe kbbug KB838910

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com