Limitations to Excel Add-Ins

D

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top