XL2000: Custom Toolbar Is Lost When Workbook Is Sent as Attachment

• Microsoft Excel 2000

SYMPTOMS

When you open a Microsoft Excel 2000 workbook that has an attached toolbar, the toolbar may not be present.

CAUSE

This occurs if the following conditions are true:

1. You create a custom toolbar in Excel 2000.



2. You use the Send to Mail Recipient (as Attachment) command to send the workbook that contains the custom toolbar to a mail recipient.



3. After sending the workbook, you delete the custom toolbar.



4. You re-open the sent workbook.

RESOLUTION

To work around this problem, do one of the following:

• Save the workbook and send it through the mail client as an attachment.


-or-


• Use an Auto_Open macro to create the custom toolbar in the workbook.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about Auto_Open macros, click Microsoft Excel Help on the Help menu, type RunAutoMacros method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: xl2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug