XL97: Imported Toolbox Page Loses Caption and Tip Text

Last reviewed: January 15, 1998
Article ID: Q159338
The information in this article applies to:
  • Microsoft Excel 97 for Windows

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 uses 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, do the following:

  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.

  4. Click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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, do the following:

  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 with the caption "New Page" to the Toolbox. The page has the Select Objects control on it.

Exporting a Page from the Toolbox

To export a page from the Toolbox, do the following:

  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.

  5. 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, do the following:

  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 with the caption "New Page" in the Toolbox. 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.

REFERENCES

For more information about exporting toolbox pages, in the Visual Basic Editor, click the Index tab in Visual Basic for Applications Help, type the following text

   exporting

and then double-click the selected text to go to the "Import or export a Toolbox page" topic.


Additional query words: XL97
Keywords : xlui xlvbainfo kbtool
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 15, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.