Limitations to Excel Add-Ins

[danmyers01]

I have been working on creating an excell add-in. During the first
week or so, I tested the add-in by "adding it" through the Tools>Add-
ins process. It worked fine then. But since then I have been
building the code in it and just today when I tried to access it using
the Tools>Add-ins process, I get the error that it is not a valid add-
in. Does anybody have some ideas on what I could have done to make it
not a valid add-in? Are there size limitations, exclusions of certain
subroutines or library references, etc?

I have made some 'empty' add ins just to test, and they loaded fine.

Thanks in advance for any help

Dan

 

[RB Smissaert]

Is the extension still .xla?

If it is then open the add-in as a normal workbook, so not via Tools,
Add-ins,
then go to the VBE, Select the ThisWorkbook module of that add-in and do
View, Properties and make sure IsAddin is True.
If it is not then change and safe.

RBS

 

[danmyers01]

thanks RBS ... that was the ticket

Dan