DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 255899 - Last Review: October 20, 2013 - Revision: 1.3

 
This article was previously published under Q255899
This article has been archived. It is offered "as is" and will no longer be updated.

On This Page

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  (http://support.microsoft.com/kb/168848/EN-US/ ) XL97: Problem with ActiveX Control After Moving Sheet

APPLIES TO
  • Microsoft Excel 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbdtacode kbfix kbprogramming KB255899
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support