Knowledge Base

XL98: Multiple File Type Choices Are Available When Saving Excel Add-In

Article ID: 179577

Article Last Modified on 9/11/2002

Microsoft Excel 98 for Macintosh

This article was previously published under Q179577

SYMPTOMS

When you save a workbook as an add-in in Microsoft Excel 98 Macintosh Edition, it is possible to choose a file format other than the add-in format.

WORKAROUND

When you save the workbook, verify that you are saving the workbook in Microsoft Excel Add-In file format. To save an add-in, follow these steps:

Start Microsoft Excel 98.
On the Tools menu, point to Macro, and then click Visual Basic Editor.
In the Project window, click ThisWorkbook.
On the View menu, click Properties window.
Set the IsAddin property to True.
On the File menu, click save Workbook1.
Select Microsoft Excel Add-In in the Save Files as Type list.
Click Save.

STATUS

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

MORE INFORMATION

Add-ins are programs that add optional commands and features to Microsoft Excel. Add-ins are installed, by default, in the Library folder in the Microsoft Excel folder. Loading an add-in makes the feature available in Microsoft Excel and adds any associated commands to the appropriate menus.

For additional information, please see the following article in the Microsoft Knowledge Base:

179008 MacXL: How to Create an Add-in File in Microsoft Excel

REFERENCES

For more information about Excel Add-Ins, click the Index tab in Microsoft Excel Help, and type the following text,

add-in programs, loading and unloading

and then double-click the selected text to go to the "Use add-in programs of Microsoft Excel" topic.

Additional query words: XL98 add in

Keywords: kbbug kbprogramming kbpending KB179577