Microsoft KB Archive/211986

= XL2000: Imported Toolbox Page Loses Caption and Tip Text =

Article ID: 211986

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211986





SYMPTOMS
When you import a page into the Microsoft Visual Basic Editor Toolbox, the Caption and the Control Tip Text settings for the page are not imported. Instead, the page tab displays the generic caption New Page, and no tip text is associated with the page.



CAUSE
This problem occurs because the Caption and Control Tip Text settings of a Toolbox page are not saved with the .pag file that is created when you export the page.



WORKAROUND
To restore the Caption and Control Tip Text settings of a Toolbox page that you import into the Toolbox, follow these steps:
 * 1) Right-click the tab for the page.
 * 2) On the shortcut menu, click Rename.
 * 3) In the Rename dialog box, type the text in the Caption and Control Tip Text boxes and then click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
The Toolbox contains all the standard Visual Basic for Applications controls and any ActiveX controls and objects (that can be inserted) that you added to the project. By default, the Toolbox has a single page called Controls, but you can customize the Toolbox by adding one or more other pages. You can either manually create a page for the Toolbox or import a page that you export from another project.

Manually Creating a Page in the Toolbox
To manually create a new page in the Toolbox, follow these steps:
 * 1) Right-click the tab for any page in the Toolbox.
 * 2) Click New Page on the shortcut menu.

NOTE: These steps add a page to the Toolbox. The tab of this page displays the caption New Page. This page has the Select Objects control on it.

Exporting a Page from the Toolbox
To export a page from the Toolbox, follow these steps:
 * 1) In the Toolbox, activate the page that you want to export.
 * 2) Right-click the tab for the page.
 * 3) Click Export Page on the shortcut menu.
 * 4) In the Export Page dialog box, type a name for the file in the File name box. Then click Save.

These steps save a .pag file in the directory that you specify in Step 4.

Importing a Page from the Toolbox
To import a page into the Toolbox, follow these steps:
 * 1) Right-click the tab for any page in the Toolbox.
 * 2) Click Import Page on the shortcut menu.
 * 3) In the Import Page dialog box, locate and select the .pag file you want to import.
 * 4) Click Open.

These steps add a new page to the Toolbox. The tab of this page displays the caption New Page. The page has all the controls that were in the page when you exported it. However, the page does not have the same caption and does not have any tip text.

Additional query words: XL2000

Keywords: kbbug kbpending KB211986

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.