Creating an Addin

Converting a workbook to an Add-in is a trivial exercise, on the face of it. Make sure that a worksheet is active in your workbook, click the Microsoft Office button, select Save As, scroll down the dropdown labeled Save as type:, and choose Excel Add-In (*.xlam). Excel will automatically position you in a special Add-ins folder, although there is no requirement that you use it. The advantage of this method is that you do not overwrite the original .xlsm file, and you create a file with the .xlam extension that distinguishes it as an Add-in to the operating system.

Note that you must have a worksheet active when using Save As to create an Add-in. Otherwise, you will not find the .xlam type offered as an option.

An easier way to create an Add-in is to change the IsAddin property of ThisWorkbook to True in the Properties window, as shown in Figure 17-2.

1

ff Properties-ThisWorkbook =JiaJEi

ThisWorkbook Workbook

Ivl

Alphabetic Categorized

(Name)

ThlsWoritbool;

AutoUpdatt Frequency'

0

Changehi5tnryDurat]on

a

ChediCornpatibilitY

False

ConfiictResolubon

I - xiUserResoiuDon

Date 1904

False

4

DisplayDrav.mgObiects

-4104 -KIDisplaiShape?

Display InkComrnents

True

DoNotPromptForConvert

False

EnableAutoRecover

TruE

i

EticryptiQnProvider

Envelope Visible

False

Final

False

HasRoufcngSlip

False

HlghlighithangesOnScreen

False

Inactj^eLiEiSorderVtsible

True

IiAdjin Faisel «1

KeepChangeHisTDrv

True

False

Figure 17-2

The disadvantage of this method is that you change the original .xlsm file to an Add-in, but its .xlsm extension remains unchanged and, when you open the file later, Excel 2007 objects to the mismatch between the file type and the extension. You need to change the file extension to .xlam manually, using the Windows Explorer.

0 0

Post a comment