Excel 2007 VBA Addin

[MR From Texas]

When I try to select a certain Addin from the Excel Options "Addins
Available" dialog box, I get a message that the "Addin is not a valid Addin.

Come someone advise me on what I should do?

MR from Texas

 

[locochon2010]

Mr. Texas

1) You need to provide more information - Is it Microsoft or some third party?
2) You have to make sure your add in is properly installed.
3) I am not sure if you have to be logged in as an administrator to install
ANYTHING, even add ins.

 

[MR From Texas]

Thanks locochon.

The VBA Addin was developed by me, and has been in use for several months.

I have developed several other excel addins and had no problems like this one.

The message has occurred wih this Addin before and I have rebuilt the addin
and it worked correctly and without any problems, but all at once, this
problem started, then I went the backup file and it worked for a while and
then the same problem occurred.

I have since tried to open the file using the Custom IU Editor and I get a
message that the file is corrupted, however, I can open the Addin in Excel,
and it actually works with the Excel workbook. However, when I try to access
the Addin using the Addins Available dialog box, I get the message "Addin is
not valid".

Mr from Texas

 

[MSweetG222]

MR From Texas,

Try "cleaning" the modules of the program in question. Rob Bovey has a
program to do this. Go to http://www.appspro.com/Utilities/CodeCleaner.htm
and download the program. I hope that works for you. Good Luck.

 

[MR From Texas]

Thanks MSweetG222

I cleaned the modules as you suggested, however, even though the cleaning
process was successful, it did not solve the problem.

MR from Texas

 

[MSweetG222]

Hmmm.

Okay. Start making a list of what is different between your other addins
and this one.

1. Directory path where addins are stored
2. Addin name (length, any special characters, etc.)
3. Encryption used (is it different than the others)
4. Password required to open?
5. Properties (anything weird in those fields?). Look both in the VBE
window for all modules (including worksheet and ThisWorkbook) and in the File
| Properties of the Excel window.
6. # of modules?
7. size of modules?
8. # of lines per module
9. Is VBA code protected with a password?
10. Is your trusted certificate in the wrong place? Is it damaged?
11. Non-VBA related things (like do you have 2 pivot tables on one worksheet
tab), etc.
12. anything else I am not thinking of right now -- sorry

Use this add in (http://www.mztools.com/v3/mztools3.aspx) to gather some of
the info above. It is free thanks to Carlos J. Quintero. There is a
"Statistics" option in one of the icons/drop downs. Run Statistics, copy and
paste that info into an Excel worksheet and compare to your other addins.
There are some recommended "self imposed" limitations regarding size of a
module (% and # of lines). I don't recall what that "limit" is at the moment
(your modules may be small, so this is may not be an issue for you. If your
addin is less than 500 lines per module, ignore this sentence).

Don't forget to compare to your other addins. What is different? Keep
looking for the difference until your find you problem.

I hope you find your issue. Good Luck.