execute an Add In

Hi,

I was under the impression that i could run an add in from the add in box by checking it and pressin ok???

xla and xlam are effectively workbooks with all of the sheets hidden (as Tiger mentioned). When you tick it in the add-in box and click OK, it installs the add-in. For xla and xlam, "installing the add-in" basically means that the add-in workbook is opened in the Excel instance: the only code that would run in the add-in at this stage would be like these:

• Workbook_Open()
• Workbook_AddinInstall()
• Auto_Open()

Once the add-in is opened, it means that the code within it, such as your Move procedure, will be available for use. A lot of people design an interface - such as a commandbar with buttons on - which is created when the add-in is opened, so that people can easily run the bit of code they want.