Microsoft Office Tutorials and References
In Depth Information
Converting a File to an Add-In
To reach the Properties information in Excel version 2007,
click the round Office button near the top-left corner
of your window. You will see a vertical pane on the
left side of the window. Click Prepare, and then in the
pane on the right, click Properties, as shown in
To reach the Properties information in Excel version
2010, click the File tab on the Ribbon, and in the
vertical pane at the left, click Info. At the far right, you
will see a Properties label with a drop-down arrow.
As indicated in Figure 22-5, selecting the Advanced
Properties item in the drop-down list displays the
Properties dialog box.
conVErTing A filE To An Add-in
The easiest way to convert a file to an add-in is to save the file as an Excel Add-in type. In
versions of Excel prior to 2007, from the worksheet menu click File ➪ Save As. In the Save As dialog
box, navigate to the folder where you want the add-in to reside. In Figure 22-6, I named the file
SheetManager , and I created a subfolder named My Addins . From the Save As Type field’s
dropdown list, select Microsoft Office Excel Add-In, as shown in Figure 22-6, and click the Save button.
For version 2007, click the Office button and select Save As. For version 2010, click the File tab and
select Save As. In the Save As dialog box, navigate to the folder where you want the add-in to reside,
and give the file a name. As shown in Figure 22-7, select Excel Add-In from the Save As Type
dropdown list and click the Save button.