XL97: ActiveX Control Names Change When You Move or Copy Worksheet (255899)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q255899

SYMPTOMS

When you use the Move or Copy Sheet command on a worksheet that contains ActiveX controls, the Name property of controls may change.

CAUSE

This problem occurs if you do either of the following before you copy or move the worksheet:
  • You change the name of the controls to a custom name.

    -or-

  • You delete one or more controls of the same type.
For specific examples of this problem, see the "More Information" section later in this article.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem no longer occurs in Microsoft Excel 2000.

MORE INFORMATION

The Control Toolbox toolbar contains ActiveX controls that you can insert into your worksheet, or into a form in your Microsoft Visual Basic for Applications project. However, when you insert these controls in a worksheet and you then move or copy that sheet, the names of the controls may change.

The following examples illustrate this problem.

User-Defined Names Change to Default Names

  1. On the View menu, point to Toolbars, and then click Control Toolbox.
  2. On Sheet1, create the following controls, and change the names of the controls to those listed in the following table:

       Control          Name
   -------          ---------
   TextBox          txtInput
   ListBox          lstChoice
   CommandButton    cmdOK
    To change the name, right-click the control, and then click Properties on the shortcut menu. Type the new name in the (Name) box.

    NOTE: You may need to first click the Design Mode button on the Control Toolbox toolbar.
  3. On the Edit menu, click Move or Copy Sheet. In the Move or Copy dialog box, click (new book) in the To book list. Click to select the Create a copy check box, and then click OK.
Notice in the new workbook, the names for the three controls have changed to their defaults of TextBox1, ListBox1, and CommandButton1.

Deleting Controls Reorders Their Names

  1. On the View menu, point to Toolbars, and then click Control Toolbox.
  2. On Sheet1, create the following controls: 
       Control          Default Name
   -------          ------------
   TextBox          TextBox1
   TextBox          TextBox2
   TextBox          TextBox3
    Notice the names of the controls listed in the table above. To view the name, right-click the control, and then click Properties on the shortcut menu. The control's name is shown in the Name box.

    NOTE: You may need to first click the Design Mode button on the Control Toolbox toolbar.
  3. Delete TextBox1.
  4. On the Edit menu, click Move or Copy Sheet. In the Move or Copy dialog box, click (new book) in the To book list. Click to select the Create a copy check box, and then click OK.
Notice that in the new workbook, Excel has reordered and changed the names of the two text box controls to TextBox1 and TextBox2.

REFERENCES

For additional information about problems with ActiveX controls after you move a worksheet, click the article number below to view the article in the Microsoft Knowledge Base:

168848 XL97: Problem with ActiveX Control After Moving Sheet

Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbbug kbdtacode kbfix kbProgramming KB255899
©2004 Microsoft Corporation. All rights reserved.