file.xlam' is not a valid add-in

Hi,

I'm trying to remember. I had originally created this add in and loaded in excel (2007) before, but now when I try to point to the file, I get the above message box. The file has two forms, and one exposed (public) subroutine in a module. I can no longer see it in my add-ins when I try to see them.

Not sure what I screwed up, but I need to fix this and pretty fast.

Help!

Thanks,

Steve

Good morning steven_b46

Try going into the VBE and look under the ThisWorkbook object of the file in question, there should be a property listed called IsAddin. This needs to be set to True.
If this doesn't work you might want to upload the file.

HTH

DominicB

Thanks dominicb!

I had did that, but the xlam has no sheets. I rebuilt the xlam, by creating a new one, copying over forms and recreating the module, I made sure I said yes to the isAddin property.

Doesn't really make sense to me, but hey it works.

Hi steven_b46

It will have had sheets - you can't have a workbook without sheets - addin or not.
Setting the IsAddin property just allows you to open the file without showing the sheet. You can even reference data in the sheet from the addin itself - that's a cheeky trick that not many people know

Glad you got sorted.

DominicB