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:
- Start Excel 2002.
- On the View menu, point to
Toolbars, and then click Control Toolbox.
- On the Control Toolbox, click the
Command Button icon.
- Move the command button to cell H8.
- On the File menu, click
- Click Print .
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.
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:
- Right-click the command button, and then click
- On the Properties tab, click Move and size with cells.
- Click OK.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
How to obtain the hotfixThis 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
Article ID: 838910 - Last Review: Feb 15, 2017 - Revision: 2
Microsoft Excel 2002 Standard Edition