Not a valid Add-in - Error Message

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

Excel 2000, Win2k.

If I try to add an add-in via the add-in manager, I receive the
message: 'Not a valid add-in'. This message appears for just
this particular add-in, AFAIK.

If I browse to that add-in, double click it and then enable
macros, then it loads ok (together with its menu) and appears
to work ok.

What is happening, please?
 
Stuart,

Open the add-in as a workbook (not via add-in manager), then goto the VBE,
select ThisWorkbook for the add-in, and check that the IsAddin property is
set to True.
 
That was the problem.
Many thanks.

Regards.

Bob Phillips said:
Stuart,

Open the add-in as a workbook (not via add-in manager), then goto the VBE,
select ThisWorkbook for the add-in, and check that the IsAddin property is
set to True.

--

HTH

RP
 

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

Back
Top